DBA Data[Home] [Help]

APPS.PAY_GB_EOY_ARCHIVE dependencies on PAY_ACTION_INTERLOCKS

Line 3751: FROM pay_action_interlocks pai,

3747: */
3748: AND pact.effective_date <= p_asg_last_eff_date
3749: AND NOT EXISTS(
3750: SELECT '1'
3751: FROM pay_action_interlocks pai,
3752: pay_assignment_actions assact3,
3753: pay_payroll_actions pact3
3754: WHERE pai.locked_action_id = assact2.assignment_action_id
3755: AND pai.locking_action_id = assact3.assignment_action_id

Line 3800: FROM pay_action_interlocks pai,

3796: */
3797: AND pact.effective_date <= p_asg_last_eff_date
3798: AND NOT EXISTS(
3799: SELECT '1'
3800: FROM pay_action_interlocks pai,
3801: pay_assignment_actions assact3,
3802: pay_payroll_actions pact3
3803: WHERE pai.locked_action_id = assact2.assignment_action_id
3804: AND pai.locking_action_id = assact3.assignment_action_id