DBA Data[Home] [Help]

APPS.PAY_GB_EOY_ARCHIVE dependencies on PAY_ACTION_INTERLOCKS

Line 3611: FROM pay_action_interlocks pai,

3607: */
3608: AND pact.effective_date <= p_asg_last_eff_date
3609: AND NOT EXISTS(
3610: SELECT '1'
3611: FROM pay_action_interlocks pai,
3612: pay_assignment_actions assact3,
3613: pay_payroll_actions pact3
3614: WHERE pai.locked_action_id = assact2.assignment_action_id
3615: AND pai.locking_action_id = assact3.assignment_action_id

Line 3659: FROM pay_action_interlocks pai,

3655: */
3656: AND pact.effective_date <= p_asg_last_eff_date
3657: AND NOT EXISTS(
3658: SELECT '1'
3659: FROM pay_action_interlocks pai,
3660: pay_assignment_actions assact3,
3661: pay_payroll_actions pact3
3662: WHERE pai.locked_action_id = assact2.assignment_action_id
3663: AND pai.locking_action_id = assact3.assignment_action_id