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