APPS.PAY_US_GEOCODE_REPORT_PKG dependencies on PAY_US_EMP_CITY_TAX_RULES_F

Line 1635: INDEX (PAY_US_EMP_CITY_TAX_RULES_F PAY_US_EMP_CITY_TAX_RULES_N3) */

1631:
1632: SELECT /*+ ORDERED
1633: INDEX (PAY_US_MODIFIED_GEOCODES PAY_US_MODIFIED_GEOCODES_N1)
1634: INDEX (PAY_US_CITY_NAMES PAY_US_CITY_NAMES_FK1)
1635: INDEX (PAY_US_EMP_CITY_TAX_RULES_F PAY_US_EMP_CITY_TAX_RULES_N3) */
1636: SUBSTR(ppf.full_name,1,40),
1637: SUBSTR(pmod.city_name,1,20),
1638: SUBSTR(pucn.city_name,1,20)
1639: FROM pay_us_modified_geocodes pmod,

Line 1641: pay_us_emp_city_tax_rules_f ectr,

1637: SUBSTR(pmod.city_name,1,20),
1638: SUBSTR(pucn.city_name,1,20)
1639: FROM pay_us_modified_geocodes pmod,
1640: pay_us_city_names pucn,
1641: pay_us_emp_city_tax_rules_f ectr,
1642: per_assignments_f paf,
1643: per_people_f ppf
1644: WHERE pmod.process_type = 'P'
1645: AND pmod.state_code = pucn.state_code

Line 1659: INDEX (PAY_US_EMP_CITY_TAX_RULES_F PAY_US_EMP_CITY_TAX_RULES_N3) */

1655: union all
1656: SELECT /*+ ORDERED
1657: INDEX (PAY_US_MODIFIED_GEOCODES PAY_US_MODIFIED_GEOCODES_N1)
1658: INDEX (PAY_US_CITY_NAMES PAY_US_CITY_NAMES_FK1)
1659: INDEX (PAY_US_EMP_CITY_TAX_RULES_F PAY_US_EMP_CITY_TAX_RULES_N3) */
1660: SUBSTR(ppf.full_name,1,40),
1661: SUBSTR(pucn.city_name,1,20),
1662: SUBSTR(pmod.city_name,1,20)
1663: FROM pay_us_modified_geocodes pmod,

Line 1665: pay_us_emp_city_tax_rules_f ectr,

1661: SUBSTR(pucn.city_name,1,20),
1662: SUBSTR(pmod.city_name,1,20)
1663: FROM pay_us_modified_geocodes pmod,
1664: pay_us_city_names pucn,
1665: pay_us_emp_city_tax_rules_f ectr,
1666: per_assignments_f paf,
1667: per_people_f ppf,
1668: hr_s_us_city_names pmod2
1669: WHERE pmod.process_type = 'S'

Line 2603: pay_us_emp_city_tax_rules_f ectr,

2599: substr(puc1.county_name,1,20),
2600: pmod.state_code||'-'||pmod.new_county_code||'-'||pmod.new_city_code "New JD",
2601: substr(puc2.county_name,1,20)
2602: FROM pay_us_modified_geocodes pmod,
2603: pay_us_emp_city_tax_rules_f ectr,
2604: per_assignments_f paf,
2605: per_people_f ppf,
2606: pay_us_counties puc1,
2607: pay_us_counties puc2

Line 3109: pay_us_emp_city_tax_rules_f pctr

3105: from hr_locations_all hla
3106: where hla.location_id in
3107: (select distinct location_id
3108: from per_assignments_f paf,
3109: pay_us_emp_city_tax_rules_f pctr
3110: where ( ( pctr.STATE_CODE = '26'
3111: and pctr.county_code = '510'
3112: and pctr.city_code = '1270')
3113: or ( pctr.state_code = '21'

Line 3388: pay_us_emp_city_tax_rules_f pctr

3384: where addr.person_id = ppf.person_id
3385: and ppf.person_id in
3386: (select distinct person_id
3387: from per_assignments_f paf,
3388: pay_us_emp_city_tax_rules_f pctr
3389: where ( ( pctr.STATE_CODE = '26'
3390: and pctr.county_code = '510'
3391: and pctr.city_code = '1270')
3392: or ( pctr.state_code = '21'