DBA Data[Home] [Help]

APPS.PAY_US_W2C_REPORTING_UTILS dependencies on PAY_ACTION_INTERLOCKS

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

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