APPS.PAY_HK_IR56_ARCHIVE dependencies on PAY_PAYROLLS_F

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

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