APPS.PA_UTILS dependencies on HR_LOCATIONS

Line 1000: from hr_locations l

996: BEGIN
997: IF p_location_id is not null then
998: select l.location_id
999: into l_location_id
1000: from hr_locations l
1001: where X_Date < nvl(l.inactive_date, to_date('4712/12/31', 'YYYY/MM/DD'))
1002: and (l.location_use = 'HR')
1003: and location_id = p_location_id;
1004: ELSE

Line 1007: from hr_locations l

1003: and location_id = p_location_id;
1004: ELSE
1005: select l.location_id
1006: into l_location_id
1007: from hr_locations l
1008: where X_Date < nvl(l.inactive_date, to_date('4712/12/31', 'YYYY/MM/DD'))
1009: and (l.location_use = 'HR')
1010: and location_code = p_location_code;
1011: END IF;