Query: People Fedral Tax Rules

select
    ppf.employee_number                                         "Employee Number",
    --
    (select state_name
        from pay_us_states
        where state_abbrev = add_information17)               "Resident",
    (select hlat.region_2
       from hr_locations_all hlat
      where hlat.location_id = paaf.location_id)              "Work",
    pus.state_name                                            "SUI State",
    paa.add_information18                                     "Resident City",
    pus.state_name                                            "Work City",
    paa.add_information19                                     "Resident County",
     (select hlat.region_1
       from hr_locations_all hlat
      where hlat.location_id = paaf.location_id)               "Work County",
    hrl1.meaning                                              "Filing Status",
    ftr.withholding_allowances                                 "Allowances",
    ftr.fit_additional_tax                                     "Additional Tax",
    ftr.fit_exempt                                             "Tax Exemption :Fit",
    ftr.futa_tax_exempt                                        "Tax Exemption :FUTA",
    ftr.medicare_tax_exempt                                    "Tax Exemption :MEDICARE",
    ftr.ss_tax_exempt                                          "Tax Exemption :SS",
    ftr.fit_override_amount                                   "FO:Regular Amount",
    ftr.fit_override_rate                                     "FO:Regular Rate",
    ftr.supp_tax_override_rate                                 "FO:Supplemental Rate",
    ftr.excessive_wa_reject_date                               "Lock in Date",
    ftr.statutory_employee                                     "Statutory Employee",
    ftr.cumulative_taxation                                    "Cumulative Taxation",
    ftr.wage_exempt                                            "FIt Exempt Wage Acc",
    hrl2.meaning                                               "EIC filling status",
    ftr.effective_start_date                                  "Effec Dates: From",
    decode (ftr.effective_end_date,
    to_date ('31124712', 'DDMMYYYY'), null,
    ftr.effective_end_date)                                   "Effec Dates: To",
    --
    ftr.emp_fed_tax_rule_id,
    paaf.assignment_id,
    paaf.location_id,
    paa.address_id
    --
from
    pay_us_emp_fed_tax_rules_f ftr,
    per_all_assignments_f paaf,
    pay_us_states pus,
    per_addresses paa,
    hr_lookups hrl1,
    hr_lookups hrl2,
    per_people_f ppf
where  
    ftr.sui_state_code = pus.state_code
and ftr.assignment_id=paaf.assignment_id
and paa.person_id=paaf.person_id
and ftr.filing_status_code = hrl1.lookup_code
and hrl1.lookup_type = 'US_FIT_FILING_STATUS'
and ftr.eic_filing_status_code = hrl2.lookup_code
and hrl2.lookup_type = 'US_EIC_FILING_STATUS'
and nvl(paaf.effective_end_date,sysdate)>sysdate-1
and ftr.assignment_id = paaf.assignment_id
and paaf.person_id = ppf.person_id
--
and ppf.employee_number='1309'
order by
      1,2;