APPS.HR_US_FF_UDF1 dependencies on PAY_US_CITY_NAMES

Line 5522: pay_us_city_names pucty,

5518: CURSOR c_override_jd (p_assignment_id IN NUMBER,p_date_earned IN DATE) IS
5519: SELECT puc.state_code || '-' || puc.county_code || '-' ||pucty.city_code
5520: FROM pay_us_counties puc,
5521: pay_us_states pus,
5522: pay_us_city_names pucty,
5523: per_addresses pa,
5524: per_assignments_f paf
5525: WHERE paf.assignment_id = p_assignment_id
5526: AND paf.person_id = pa.person_id

Line 5547: pay_us_city_names pucty,

5543: CURSOR c_jd (p_assignment_id IN NUMBER,p_date_earned IN DATE) IS
5544: SELECT puc.state_code || '-' || puc.county_code || '-' ||pucty.city_code
5545: FROM pay_us_counties puc,
5546: pay_us_states pus,
5547: pay_us_city_names pucty,
5548: per_addresses pa,
5549: per_assignments_f paf
5550: WHERE paf.assignment_id = p_assignment_id
5551: AND paf.person_id = pa.person_id

Line 5610: pay_us_city_names pucty,

5606: p_jurisdiction_code IN VARCHAR2) IS
5607: SELECT puc.state_code || '-' || puc.county_code || '-' ||pucty.city_code
5608: FROM pay_us_counties puc,
5609: pay_us_states pus,
5610: pay_us_city_names pucty,
5611: hr_locations hl,
5612: per_assignments_f paf
5613: WHERE paf.assignment_id = p_assignment_id
5614: AND TO_DATE('01-01-'||TO_CHAR(p_date_earned,'YYYY'), 'DD-MM-YYYY') BETWEEN

Line 5633: pay_us_city_names pucty,

5629: p_jurisdiction_code IN VARCHAR2) IS
5630: SELECT puc.state_code || '-' || puc.county_code || '-' ||pucty.city_code
5631: FROM pay_us_counties puc,
5632: pay_us_states pus,
5633: pay_us_city_names pucty,
5634: hr_locations hl,
5635: per_assignments_f paf
5636: WHERE paf.assignment_id = p_assignment_id
5637: AND TO_DATE('01-01-'||TO_CHAR(p_date_earned,'YYYY'), 'DD-MM-YYYY') BETWEEN