APPS.PAY_HK_IR56_ARCHIVE dependencies on PAY_PAYROLLS_F

Line 243: pay_payrolls_f pay, /* Added for Bug 3916743 - performance fix. */

239: c_fin_end_date date )
240: IS
241: SELECT distinct pac.assignment_id
242: FROM pay_payroll_actions ppa,
243: pay_payrolls_f pay, /* Added for Bug 3916743 - performance fix. */
244: pay_assignment_actions pac
245: WHERE ppa.action_type in ('R','B','I','Q')
246: AND ppa.payroll_action_id = pac.payroll_action_id
247: AND ppa.business_group_id = c_business_group_id