DBA Data[Home] [Help]

APPS.HR_H2PI_MAPPING_SETUP dependencies on HR_H2PI_PAY_BASES_V

Line 51: hr_h2pi_pay_bases_v ppb2

47: ppb2.pay_basis_id,
48: l_to_business_group_id,
49: 'PER_PAY_BASES'
50: FROM hr_h2pi_pay_bases ppb1,
51: hr_h2pi_pay_bases_v ppb2
52: WHERE ppb1.client_id = l_from_client_id
53: AND ppb2.business_group_id = l_to_business_group_id
54: AND ppb1.name = ppb2.name
55: AND NOT EXISTS (SELECT 1