APPS.PQP_GB_TP_EXT_PROCESS dependencies on HR_LOCATIONS_ALL

Line 1653: ,hr_locations_all loc

1649: SELECT loc.location_code
1650: ,loc.location_id
1651: ,lei.lei_information6 lea_number
1652: FROM hr_organization_units_v org
1653: ,hr_locations_all loc
1654: ,hr_location_extra_info lei
1655: WHERE org.organization_id = p_organization_id
1656: AND loc.location_id = org.location_id
1657: AND lei.location_id(+) = loc.location_id

Line 1668: l_location_code hr_locations_all.location_code%TYPE := NULL;

1664:
1665: PROGRAM_FAILURE CONSTANT NUMBER := 2 ;
1666: PROGRAM_SUCCESS CONSTANT NUMBER := 0 ;
1667:
1668: l_location_code hr_locations_all.location_code%TYPE := NULL;
1669: l_location_id hr_locations_all.location_id%TYPE := NULL;
1670: l_curr_bg_id per_all_people_f.business_group_id%TYPE;
1671: l_request_id fnd_concurrent_requests.request_id%TYPE;
1672: l_retcode NUMBER := PROGRAM_SUCCESS;

Line 1669: l_location_id hr_locations_all.location_id%TYPE := NULL;

1665: PROGRAM_FAILURE CONSTANT NUMBER := 2 ;
1666: PROGRAM_SUCCESS CONSTANT NUMBER := 0 ;
1667:
1668: l_location_code hr_locations_all.location_code%TYPE := NULL;
1669: l_location_id hr_locations_all.location_id%TYPE := NULL;
1670: l_curr_bg_id per_all_people_f.business_group_id%TYPE;
1671: l_request_id fnd_concurrent_requests.request_id%TYPE;
1672: l_retcode NUMBER := PROGRAM_SUCCESS;
1673: l_wait_success BOOLEAN := FALSE;