[Home] [Help]
129: CURSOR csr_element_set_name(cp_arch_assignment_action_id NUMBER) IS
130: SELECT pes.element_set_name
131: FROM pay_element_sets_vl pes,
132: pay_payroll_actions rppa, -- run pact
133: pay_assignment_actions rpaa, -- run assact
134: pay_action_interlocks rpai -- run interlock by archive assact
135: WHERE rpai.locking_action_id = cp_arch_assignment_action_id
136: AND rpaa.assignment_action_id = rpai.locked_action_id
137: AND rppa.payroll_action_id = rpaa.payroll_action_id
211: prrv.input_value_id,
212: prrv.result_value,
213: decode(pbf.scale, 1, 'E', -1, 'D', 'O') payment_type
214: FROM pay_action_interlocks pai, -- run interlock by archive assact
215: pay_assignment_actions rpaa, -- run assact
216: pay_payroll_actions rppa, -- run pact
217: pay_run_results prr,
218: pay_run_result_values prrv,
219: pay_balance_feeds_f pbf,
347: ppaa.assignment_action_id prepay_assignment_action_id,
348: pppa.effective_date prepay_effective_date,
349: ppaa.assignment_id prepay_assignment_id
350: from pay_action_interlocks ppai, -- prepay interlocks by arch assact
351: pay_assignment_actions ppaa, -- prepay assact
352: pay_payroll_actions pppa -- prepay pact
353: where ppai.locking_action_id = cp_arch_assignment_action_id
354: and ppaa.assignment_action_id = ppai.locked_action_id
355: and pppa.payroll_action_id = ppaa.payroll_action_id
382: opm.currency_code,
383: ppm.personal_payment_method_id
384: from (
385: select paa.assignment_action_id
386: from pay_assignment_actions paa
387: connect by prior paa.assignment_action_id = paa.source_action_id
388: start with paa.assignment_action_id = cp_prepay_assignment_action_id
389: ) v,
390: pay_pre_payments ppp,
545: prrv.result_value,
546: piv.lookup_type,
547: piv.value_set_id
548: FROM pay_action_interlocks rpai, -- run interlock by archive assact
549: pay_assignment_actions rpaa, -- run assact
550: pay_payroll_actions rppa, -- run pact
551: pay_run_results prr,
552: hr_organization_information hoi,
553: pay_element_types_f pet,
761: ppaa.assignment_action_id prepay_assignment_action_id,
762: rpaa.assignment_action_id run_assignment_action_id
763: FROM pay_payroll_actions xppa, -- archive pact
764: pay_payroll_actions pppa, -- prepay pact
765: pay_assignment_actions ppaa, -- prepay assact
766: per_all_assignments_f paaf,
767: pay_action_interlocks rpai, -- run interlock by archive assact
768: pay_assignment_actions rpaa, -- run assact
769: pay_payroll_actions rppa -- run pact
764: pay_payroll_actions pppa, -- prepay pact
765: pay_assignment_actions ppaa, -- prepay assact
766: per_all_assignments_f paaf,
767: pay_action_interlocks rpai, -- run interlock by archive assact
768: pay_assignment_actions rpaa, -- run assact
769: pay_payroll_actions rppa -- run pact
770: WHERE xppa.payroll_action_id = cp_payroll_action_id
771: AND pppa.payroll_id = cp_payroll_id
772: AND pppa.consolidation_set_id = cp_consolidation_set_id
792: AND NOT EXISTS(
793: SELECT /*+ ORDERED */
794: NULL
795: FROM pay_action_interlocks xpai2,
796: pay_assignment_actions xpaa2,
797: pay_payroll_actions xppa2
798: WHERE xpai2.locked_action_id = ppaa.assignment_action_id
799: AND xpaa2.assignment_action_id = xpai2.locking_action_id
800: AND xppa2.payroll_action_id = xpaa2.payroll_action_id
803: AND NOT EXISTS(
804: SELECT /*+ ORDERED */
805: null
806: FROM pay_action_interlocks vpai,
807: pay_assignment_actions vpaa,
808: pay_payroll_actions vppa
809: WHERE vpai.locked_action_id = rpaa.assignment_action_id
810: AND vpaa.assignment_action_id = vpai.locking_action_id
811: AND vppa.payroll_action_id = vpaa.payroll_action_id
827: -- Even if multiple prepayment processes match the condition of archiving, only single assignment
828: -- action for archiving process should be created.
829: --
830: IF (l_prepay_assignment_id is null) or (l_prepay_assignment_id <> l_asg_rec.prepay_assignment_id) THEN
831: SELECT pay_assignment_actions_s.NEXTVAL
832: INTO l_arch_assignment_action_id
833: FROM dual;
834: --
835: -- create an archive assignment action for the master assignment action
833: FROM dual;
834: --
835: -- create an archive assignment action for the master assignment action
836: --
837: hr_utility.trace('inserting into PAY_ASSIGNMENT_ACTIONS');
838: hr_utility.trace('arch_assignmen_action_id : ' || to_char(l_arch_assignment_action_id));
839: hr_utility.trace('arch_assignment_id : ' || to_char(l_asg_rec.prepay_assignment_id));
840: --
841: hr_nonrun_asact.insact(l_arch_assignment_action_id, l_asg_rec.prepay_assignment_id, p_payroll_action_id, p_chunk, NULL);
919: l_run_assignment_id,
920: l_run_effective_date,
921: l_time_period_id,
922: l_organization_id
923: from pay_assignment_actions xpaa, -- archive assact
924: pay_action_interlocks rpai, -- run interlock by archive
925: pay_assignment_actions rpaa, -- run assact
926: pay_payroll_actions rppa, -- run pact
927: per_all_assignments_f asg
921: l_time_period_id,
922: l_organization_id
923: from pay_assignment_actions xpaa, -- archive assact
924: pay_action_interlocks rpai, -- run interlock by archive
925: pay_assignment_actions rpaa, -- run assact
926: pay_payroll_actions rppa, -- run pact
927: per_all_assignments_f asg
928: where xpaa.assignment_action_id = p_assignment_action_id
929: and rpai.locking_action_id = xpaa.assignment_action_id
936: and not exists(
937: select /*+ ORDERED */
938: null
939: from pay_action_interlocks rpai2, -- run interlock by archive
940: pay_assignment_actions rpaa2, -- run assact
941: pay_payroll_actions rppa2 -- run pact
942: where rpai2.locking_action_id = xpaa.assignment_action_id
943: and rpaa2.assignment_action_id = rpai2.locked_action_id
944: and rpaa2.action_sequence > rpaa.action_sequence