APPS.PQP_GB_TP_EXT_PROCESS dependencies on HR_LOCATIONS_ALL

Line 1663: ,hr_locations_all loc

1659: SELECT loc.location_code
1660: ,loc.location_id
1661: ,lei.lei_information6 lea_number
1662: FROM hr_organization_units_v org
1663: ,hr_locations_all loc
1664: ,hr_location_extra_info lei
1665: WHERE org.organization_id = p_organization_id
1666: AND loc.location_id = org.location_id
1667: AND lei.location_id(+) = loc.location_id

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

1674:
1675: PROGRAM_FAILURE CONSTANT NUMBER := 2 ;
1676: PROGRAM_SUCCESS CONSTANT NUMBER := 0 ;
1677:
1678: l_location_code hr_locations_all.location_code%TYPE := NULL;
1679: l_location_id hr_locations_all.location_id%TYPE := NULL;
1680: l_curr_bg_id per_all_people_f.business_group_id%TYPE;
1681: l_request_id fnd_concurrent_requests.request_id%TYPE;
1682: l_retcode NUMBER := PROGRAM_SUCCESS;

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

1675: PROGRAM_FAILURE CONSTANT NUMBER := 2 ;
1676: PROGRAM_SUCCESS CONSTANT NUMBER := 0 ;
1677:
1678: l_location_code hr_locations_all.location_code%TYPE := NULL;
1679: l_location_id hr_locations_all.location_id%TYPE := NULL;
1680: l_curr_bg_id per_all_people_f.business_group_id%TYPE;
1681: l_request_id fnd_concurrent_requests.request_id%TYPE;
1682: l_retcode NUMBER := PROGRAM_SUCCESS;
1683: l_wait_success BOOLEAN := FALSE;