[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_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
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,
220: pay_element_types_f_tl pettl
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
356: and pppa.action_type in ('P', 'U');
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,
554: pay_element_types_f_tl pettl,
718: --
719: p_sqlstr :=
720: 'SELECT DISTINCT per.person_id
721: FROM per_all_people_f per,
722: pay_payroll_actions ppa
723: WHERE ppa.payroll_action_id = :payroll_action_id
724: AND ppa.business_group_id + 0 = per.business_group_id
725: ORDER BY per.person_id';
726: --
759: SELECT /*+ ORDERED */
760: ppaa.assignment_id prepay_assignment_id,
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
760: ppaa.assignment_id prepay_assignment_id,
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
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
773: AND pppa.action_type IN ('P', 'U')
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
801: AND xppa2.action_type = 'X'
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
812: AND vppa.action_type = 'V')
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
930: and rpaa.assignment_action_id = rpai.locked_action_id
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
945: and rppa2.payroll_action_id = rpaa2.payroll_action_id