APPS.PAY_GB_MOVDED_EDI dependencies on PAY_ACTION_INTERLOCKS

Line 643: delete pay_action_interlocks where locked_action_id = l_locked_action_id;

639: close csr_p46_5_def_assact;
640:
641: fnd_file.put_line(fnd_file.LOG,to_char(l_locked_action_id));
642: if l_locked_action_id > 0 then
643: delete pay_action_interlocks where locked_action_id = l_locked_action_id;
644: hr_nonrun_asact.insint(l_ass_act_id,l_locked_action_id);
645: end if;
646: end if;
647:

Line 849: from pay_action_interlocks pai,

845: and assact2.action_status = 'C'
846: and pact.effective_date between l_asg_start and l_asg_end
847: and not exists(
848: select '1'
849: from pay_action_interlocks pai,
850: pay_assignment_actions assact3,
851: pay_payroll_actions pact3
852: where pai.locked_action_id = assact2.assignment_action_id
853: and pai.locking_action_id = assact3.assignment_action_id