APPS.HR_US_FF_UDF1 dependencies on HR_LOCATIONS

Line 1728: FROM hr_locations HRLOC

1724: INTO l_city,
1725: l_county,
1726: l_state,
1727: l_zip_code
1728: FROM hr_locations HRLOC
1729: , hr_soft_coding_keyflex HRSCKF
1730: , per_all_assignments_f ASSIGN
1731: WHERE l_date_earned BETWEEN ASSIGN.effective_start_date
1732: AND ASSIGN.effective_end_date

Line 2679: FROM hr_locations hrloc

2675: SELECT NVL(hrloc.loc_information18,hrloc.town_or_city),
2676: NVL(hrloc.loc_information19,hrloc.region_1),
2677: NVL(hrloc.loc_information17,hrloc.region_2),
2678: SUBSTR(NVL(hrloc.loc_information20,hrloc.postal_code),1,5)
2679: FROM hr_locations hrloc
2680: ,hr_soft_coding_keyflex hrsckf
2681: ,per_all_assignments_f assign
2682: WHERE p_date_earned BETWEEN assign.effective_start_date
2683: AND assign.effective_end_date

Line 5798: hr_locations hl,

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

Line 5821: hr_locations hl,

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