DBA Data[Home] [Help]

APPS.PAY_US_EMP_BALADJ_CLEANUP dependencies on PAY_ACTION_INTERLOCKS

Line 757: from pay_action_interlocks pai,

753: and paa.source_action_id is not null
754: and paa.action_status = 'C'
755: and not exists
756: (select 1
757: from pay_action_interlocks pai,
758: pay_assignment_actions paa1,
759: pay_payroll_actions ppa1
760: where pai.locked_action_id = paa.assignment_action_id
761: and paa1.assignment_action_id = pai.locking_action_id

Line 807: from pay_action_interlocks pai,

803: and paa.source_action_id is not null
804: and paa.action_status = 'C'
805: and not exists
806: (select 1
807: from pay_action_interlocks pai,
808: pay_assignment_actions paa1,
809: pay_payroll_actions ppa1
810: where pai.locked_action_id = paa.assignment_action_id
811: and paa1.assignment_action_id = pai.locking_action_id