APPS.PAY_PAYRG_PKG dependencies on HR_LOCATIONS_ALL

Line 37: HR_LOCATIONS_ALL.

33: 16-AUG-2000 ahanda 115.2 Uncommented exit statement and
34: added commit
35: 13-APR-2001 ahanda 115.3 Changed sort cursor and formated
36: the file. Changed HR_LOCATIONS to
37: HR_LOCATIONS_ALL.
38: 26-apr-2001 tclewis 115.4 modified the cursor(s) in the range_cursor
39: and action creation to use secure views.
40: modified the sql query in the sort_code
41: routine to use base tables.

Line 1410: hr_locations_all loc,

1406: 'Location',loc.location_code,
1407: null)
1408: into return_val
1409: from hr_all_organization_units hou, /* Assignment Org */
1410: hr_locations_all loc,
1411: per_assignments_f paf
1412: where paf.assignment_id = c_assignment_id
1413: and c_effective_date between
1414: paf.effective_start_date and paf.effective_end_date