[Home] [Help]
586: and rpaa.assignment_id = p_assignment_id
587: and rpaa.action_sequence =
588: (select max(aa.action_sequence)
589: from pay_assignment_actions aa,
590: pay_action_interlocks loc
591: where loc.locked_action_id = aa.assignment_action_id
592: and loc.locking_action_id = paa.assignment_action_id);
593: begin
594: open asg_latest_pay;
635: cursor get_run is
636: -- for prepayment action find the latest interlocked run
637: select assact.assignment_action_id
638: from pay_assignment_actions assact,
639: pay_action_interlocks loc
640: where loc.locking_action_id = p_assignment_action_id
641: and assact.assignment_action_id = loc.locked_action_id
642: order by assact.action_sequence desc ;
643:
645: -- for run action check if its been prepaid
646: select assact.assignment_action_id
647: from pay_assignment_actions assact,
648: pay_payroll_actions pact,
649: pay_action_interlocks loc
650: where loc.locked_action_id = p_assignment_action_id
651: and assact.assignment_action_id = loc.locking_action_id
652: and pact.payroll_action_id = assact.payroll_action_id
653: and pact.action_type in ('P','U') -- Removed check for costing (2846119)
738:
739: CURSOR run_ids IS
740: SELECT pai.locked_action_id
741: FROM pay_assignment_actions paa,
742: pay_action_interlocks pai
743: WHERE pai.LOCKING_ACTION_ID = p_assignment_action_id
744: AND pai.locked_action_id = paa.assignment_action_id
745: AND paa.assignment_action_id not in (select bpaa.source_action_id
746: from pay_assignment_actions bpaa
748: ORDER BY locked_action_id ASC;
749:
750: /*SELECT locked_action_id Bug 3245909 To fetch Master locked action_id only */
751: /* FROM pay_assignment_actions paa,
752: pay_action_interlocks pai
753: WHERE LOCKING_ACTION_ID = p_assignment_action_id
754: AND pai.locked_action_id = paa.assignment_action_id
755: AND paa.source_action_id IS NULL
756: ORDER BY locked_action_id ASC;*/