APPS.HR_US_FF_UDF1 dependencies on PAY_US_CITY_NAMES

Line 5709: pay_us_city_names pucty,

5705: CURSOR c_override_jd (p_assignment_id IN NUMBER,p_date_earned IN DATE) IS
5706: SELECT puc.state_code || '-' || puc.county_code || '-' ||pucty.city_code
5707: FROM pay_us_counties puc,
5708: pay_us_states pus,
5709: pay_us_city_names pucty,
5710: per_addresses pa,
5711: per_assignments_f paf
5712: WHERE paf.assignment_id = p_assignment_id
5713: AND paf.person_id = pa.person_id

Line 5734: pay_us_city_names pucty,

5730: CURSOR c_jd (p_assignment_id IN NUMBER,p_date_earned IN DATE) IS
5731: SELECT puc.state_code || '-' || puc.county_code || '-' ||pucty.city_code
5732: FROM pay_us_counties puc,
5733: pay_us_states pus,
5734: pay_us_city_names pucty,
5735: per_addresses pa,
5736: per_assignments_f paf
5737: WHERE paf.assignment_id = p_assignment_id
5738: AND paf.person_id = pa.person_id

Line 5797: pay_us_city_names pucty,

5793: p_jurisdiction_code IN VARCHAR2) IS
5794: SELECT puc.state_code || '-' || puc.county_code || '-' ||pucty.city_code
5795: FROM pay_us_counties puc,
5796: pay_us_states pus,
5797: pay_us_city_names pucty,
5798: hr_locations hl,
5799: per_assignments_f paf
5800: WHERE paf.assignment_id = p_assignment_id
5801: AND TO_DATE('01-01-'||TO_CHAR(p_date_earned,'YYYY'), 'DD-MM-YYYY') BETWEEN

Line 5820: pay_us_city_names pucty,

5816: p_jurisdiction_code IN VARCHAR2) IS
5817: SELECT puc.state_code || '-' || puc.county_code || '-' ||pucty.city_code
5818: FROM pay_us_counties puc,
5819: pay_us_states pus,
5820: pay_us_city_names pucty,
5821: hr_locations hl,
5822: per_assignments_f paf
5823: WHERE paf.assignment_id = p_assignment_id
5824: AND TO_DATE('01-01-'||TO_CHAR(p_date_earned,'YYYY'), 'DD-MM-YYYY') BETWEEN