APPS.PA_PAY_UTIL dependencies on HR_LOCATIONS

Line 108: l_location_code hr_locations.location_code%TYPE;

104: FUNCTION get_location (p_assignment_id NUMBER,
105: p_earned_date DATE)
106: return varchar2 IS
107:
108: l_location_code hr_locations.location_code%TYPE;
109:
110: begin
111: if pa_pay_util.g_expenditure_item_id is not null then
112: select location_code

Line 114: from hr_locations

110: begin
111: if pa_pay_util.g_expenditure_item_id is not null then
112: select location_code
113: into l_location_code
114: from hr_locations
115: where location_id = (select location_id
116: from pa_expenditure_items_all
117: where expenditure_item_id = pa_pay_util.g_expenditure_item_id);
118: return l_location_code;