APPS.PAY_GB_MOVDED_EDI dependencies on PAY_ACTION_INTERLOCKS

Line 453: delete pay_action_interlocks where locked_action_id = l_locked_action_id;

449: end if;
450: close csr_p46_5_def_assact;
451: fnd_file.put_line(fnd_file.LOG,to_char(l_locked_action_id));
452: if l_locked_action_id > 0 then
453: delete pay_action_interlocks where locked_action_id = l_locked_action_id;
454: hr_nonrun_asact.insint(l_ass_act_id,l_locked_action_id);
455: end if;
456: end if;
457:

Line 659: from pay_action_interlocks pai,

655: and assact2.action_status = 'C'
656: and pact.effective_date between l_asg_start and l_asg_end
657: and not exists(
658: select '1'
659: from pay_action_interlocks pai,
660: pay_assignment_actions assact3,
661: pay_payroll_actions pact3
662: where pai.locked_action_id = assact2.assignment_action_id
663: and pai.locking_action_id = assact3.assignment_action_id