46: SELECT ppb1.pay_basis_id,
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
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