[Home] [Help]
59: --
60: procedure init_globals(p_arch_payroll_action_id in number)
61: is
62: c_proc CONSTANT VARCHAR2(61) := c_package || 'init_globals';
63: l_legislative_parameters pay_payroll_actions.legislative_parameters%type;
64: l_start_pos number;
65: l_end_pos number;
66: begin
67: hr_utility.set_location('Entering ' || c_proc, 10);
76: legislative_parameters
77: into g_bg_id,
78: g_effective_date,
79: l_legislative_parameters
80: from pay_payroll_actions
81: where payroll_action_id = p_arch_payroll_action_id;
82: --
83: -- Better to change how to derive PAYSLIP_LABEL from legislative parameters.
84: -- 1. Replace all "spaces" set in PAYSLIP_LABEL legislative parameter to "underscores" when issueing concurrent programs.
128: --
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
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,
219: pay_element_types_f_tl pettl
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
355: and pppa.action_type in ('P', 'U');
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,
553: pay_element_types_f_tl pettl,
717: --
718: p_sqlstr :=
719: 'SELECT DISTINCT per.person_id
720: FROM per_all_people_f per,
721: pay_payroll_actions ppa
722: WHERE ppa.payroll_action_id = :payroll_action_id
723: AND ppa.business_group_id + 0 = per.business_group_id
724: ORDER BY per.person_id';
725: --
758: SELECT /*+ ORDERED */
759: ppaa.assignment_id prepay_assignment_id,
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
759: ppaa.assignment_id prepay_assignment_id,
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
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
772: AND pppa.action_type IN ('P', 'U')
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
800: AND xppa2.action_type = 'X'
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
811: AND vppa.action_type = 'V')
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
929: and rpaa.assignment_action_id = rpai.locked_action_id
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
944: and rppa2.payroll_action_id = rpaa2.payroll_action_id