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
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