APPS.HR_US_FF_UDF1 dependencies on HR_LOCATIONS

Line 1687: FROM hr_locations HRLOC

1683: INTO l_city,
1684: l_county,
1685: l_state,
1686: l_zip_code
1687: FROM hr_locations HRLOC
1688: , hr_soft_coding_keyflex HRSCKF
1689: , per_all_assignments_f ASSIGN
1690: WHERE l_date_earned BETWEEN ASSIGN.effective_start_date
1691: AND ASSIGN.effective_end_date

Line 2580: FROM hr_locations hrloc

2576: SELECT NVL(hrloc.loc_information18,hrloc.town_or_city),
2577: NVL(hrloc.loc_information19,hrloc.region_1),
2578: NVL(hrloc.loc_information17,hrloc.region_2),
2579: SUBSTR(NVL(hrloc.loc_information20,hrloc.postal_code),1,5)
2580: FROM hr_locations hrloc
2581: ,hr_soft_coding_keyflex hrsckf
2582: ,per_all_assignments_f assign
2583: WHERE p_date_earned BETWEEN assign.effective_start_date
2584: AND assign.effective_end_date

Line 5611: hr_locations hl,

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
5615: paf.effective_start_date AND paf.effective_end_date

Line 5634: hr_locations hl,

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
5638: paf.effective_start_date AND paf.effective_end_date