DBA Data[Home] [Help]

APPS.HR_H2PI_MAPPING_SETUP dependencies on HR_H2PI_PAYROLLS_V

Line 136: hr_h2pi_payrolls_v pay2

132: pay2.payroll_id,
133: l_to_business_group_id,
134: 'PAY_ALL_PAYROLLS_F'
135: FROM hr_h2pi_payrolls pay1,
136: hr_h2pi_payrolls_v pay2
137: WHERE pay1.payroll_name = pay2.payroll_name
138: AND pay1.client_id = l_from_client_id
139: AND pay2.business_group_id = l_to_business_group_id
140: AND NOT EXISTS (SELECT 1