DBA Data[Home] [Help]

APPS.HR_H2PI_MAPPING_SETUP dependencies on HR_H2PI_LOCATIONS_V

Line 30: hr_h2pi_locations_v loc2

26: loc2.location_id,
27: l_to_business_group_id,
28: 'HR_LOCATIONS_ALL'
29: FROM hr_h2pi_locations loc1,
30: hr_h2pi_locations_v loc2
31: WHERE loc1.client_id = l_from_client_id
32: AND loc2.business_group_id = l_to_business_group_id
33: AND loc1.location_code = loc2.location_code
34: AND NOT EXISTS (SELECT 1