DBA Data[Home] [Help]

APPS.PAY_US_W2C_REPORTING_UTILS dependencies on PAY_ACTION_INTERLOCKS

Line 173: AND exists (select 'x' from pay_action_interlocks pai,

169: AND pay_magtape_generic.date_earned(PA.effective_date,AA.assignment_id)
170: BETWEEN SS.effective_start_date and SS.effective_end_date
171: AND pay_magtape_generic.date_earned(PA.effective_date,AA.assignment_id)
172: BETWEEN PE.effective_start_date and PE.effective_end_date
173: AND exists (select 'x' from pay_action_interlocks pai,
174: pay_assignment_actions paa1,
175: pay_payroll_actions ppa1
176: where paa1.assignment_action_id = AA.assignment_action_id
177: and paa1.assignment_action_id = pai.locking_action_id