[Home] [Help]
526: l_cert_type_param varchar2(1);
527: l_itreg_batch varchar2(1);
528: rec_tax_info csr_tax_info%rowtype;
529: rec_tax_file_creater_inf csr_tax_file_creater_inf%rowtype;
530: leg_param pay_payroll_actions.legislative_parameters%type;
531: l_period_recon varchar2(30); -- 9877034 fix
532:
533: l_asg_set_id number;
534: l_person_id number;
541:
542: -- Retrieve legislative parameters from the archiver payroll action
543: select legislative_parameters
544: into leg_param
545: from pay_payroll_actions
546: where payroll_action_id = pactid;
547:
548: l_legal_entity_org := get_parameter('LEGAL_ENTITY', leg_param);
549: l_tax_year := get_parameter('TAX_YEAR', leg_param);
621: sql_range :=
622: 'SELECT distinct paf.person_id
623: FROM per_assignments_f paf,
624: pay_payrolls_f PPY,
625: pay_payroll_actions PPA,
626: per_assignment_extra_info AEI
627: WHERE PPA.payroll_action_id = :payroll_action_id
628: AND paf.business_group_id = PPA.business_group_id
629: AND paf.assignment_type = ''E''
692: -- Bug 13367825 starts
693:
694: select get_parameter('TAX_YEAR', legislative_parameters)
695: into l_tax_year
696: from pay_payroll_actions
697: where payroll_action_id = p_payroll_action_id;
698:
699: if l_tax_year < 2013 then
700: if g_code_list.exists(3615) then
743: asg.person_id person_id
744: , asg.assignment_id assignment_id
745: FROM
746: per_all_assignments_f asg
747: , pay_payroll_actions ppa_arch
748: , per_assignment_extra_info aei
749: WHERE
750: ppa_arch.payroll_action_id = pactid
751: AND asg.business_group_id + 0 = ppa_arch.business_group_id
774: AND EXISTS (SELECT /*+ ORDERED */
775: /* the ordered hint will force the paa table to be joined to first */
776: NULL
777: FROM pay_assignment_actions paa
778: , pay_payroll_actions ppa
779: , per_time_periods ptp
780: WHERE paa.assignment_id = asg.assignment_id
781: AND paa.payroll_action_id = ppa.payroll_action_id
782: AND ppa.action_type IN ('R', 'Q', 'V', 'B', 'I')
798: l_legal_entity_org number;
799: l_tax_year varchar2(4);
800: l_ppa_payroll_id number;
801: l_proc varchar2(100) := g_package||'action_creation';
802: leg_param pay_payroll_actions.legislative_parameters%type;
803: l_cert_type varchar2(1);
804: l_itreg_batch varchar2(1);
805: l_period_recon varchar2(30);
806: l_period_recon_last_date date;
812:
813: -- Get the legislative parameters from the archiver payroll action
814: select legislative_parameters,payroll_id
815: into leg_param,l_ppa_payroll_id
816: from pay_payroll_actions
817: where payroll_action_id = pactid;
818:
819: asg_set_id := get_parameter('ASG_SET_ID', leg_param);
820: person_id := get_parameter('PERSON_ID', leg_param);
839:
840: -- Update the Payroll Action with the Payroll ID
841: --
842: IF l_ppa_payroll_id IS NULL and l_payroll_id is not null THEN
843: update pay_payroll_actions
844: set payroll_id = l_payroll_id
845: where payroll_action_id = pactid;
846: END IF;
847:
1039: p_effective_date in date) as
1040:
1041: cursor curdirnum (p_ass_id in number, p_tax_year varchar2, p_period_recon_last_date date, p_period_recon varchar2) is
1042: select distinct prrv.result_value directive_number
1043: from pay_payroll_actions ppa
1044: , per_time_periods ptp
1045: , pay_assignment_actions paa
1046: , pay_run_results prr
1047: , pay_run_result_values prrv
1070: pay_element_entries_f peef,
1071: pay_link_input_values_f plivf,
1072: pay_input_values_f pivf,
1073: pay_element_types_f petf,
1074: pay_payroll_actions ppa,
1075: pay_assignment_actions paa
1076: where paa.assignment_action_id = p_run_assact_id
1077: and ppa.payroll_action_id = paa.payroll_action_id
1078: and petf.element_name = 'ZA_Tax'
1145: l_nature varchar2(2);
1146: l_independent_contractor varchar2(1);
1147: l_labour_broker varchar2(1);
1148: l_reason_for_IT3A varchar2(2);
1149: l_leg_param pay_payroll_actions.legislative_parameters%type;
1150: t_final_arch final_archive_table;
1151: t_code code_table; -- values of all codes for this assignment, index by code / code-dirnum
1152: t_dir_num dir_num_table; -- all directive numbers for this assignment,
1153: -- index by directive_number
1230: select ppa.legislative_parameters
1231: , paa.assignment_id
1232: into l_leg_param
1233: , l_assignment_id
1234: from pay_payroll_actions ppa
1235: , pay_assignment_actions paa
1236: where paa.assignment_action_id = p_assactid
1237: and ppa.payroll_action_id = paa.payroll_action_id;
1238:
1316: -- in this tax year
1317: select max(paa.action_sequence)
1318: into l_run_action_seq
1319: from pay_assignment_actions paa,
1320: pay_payroll_actions ppa,
1321: per_time_periods ptp
1322: where paa.assignment_id = l_assignment_id
1323: and paa.action_status IN ('C','S') --10376999
1324: and paa.payroll_action_id = ppa.payroll_action_id
2300: cursor csr_employee_info_rec is
2301: select pai.action_information30
2302: , pai.action_context_id
2303: , pai.action_context_type
2304: from pay_payroll_actions ppa
2305: , pay_assignment_actions paa
2306: , pay_action_information pai
2307: where ppa.payroll_action_id = pactid
2308: and ppa.action_status = 'C'
2317:
2318: l_req_id NUMBER ;
2319: l_start_date DATE;
2320: l_end_date DATE;
2321: leg_param pay_payroll_actions.legislative_parameters%type;
2322: l_legal_entity_org number;
2323: l_tax_year varchar2(4);
2324: l_proc varchar2(100) := g_package||'deinit_code';
2325: l_cert_type varchar2(1);
2332: hr_utility.set_location('Entering '|| l_proc,10);
2333:
2334: select legislative_parameters
2335: into leg_param
2336: from pay_payroll_actions
2337: where payroll_action_id = pactid;
2338:
2339: l_legal_entity_org := get_parameter('LEGAL_ENTITY', leg_param);
2340: l_tax_year := get_parameter('TAX_YEAR', leg_param);
2760: select ppa.legislative_parameters
2761: , paa.assignment_id
2762: into l_leg_param
2763: , l_assignment_id
2764: from pay_payroll_actions ppa
2765: , pay_assignment_actions paa
2766: where paa.assignment_action_id = p_assactid
2767: and ppa.payroll_action_id = paa.payroll_action_id ;
2768:
2803: -- was run in this tax year
2804: select max(paa.action_sequence)
2805: into l_max_act_seq
2806: from pay_assignment_actions paa
2807: , pay_payroll_actions ppa
2808: , per_time_periods ptp
2809: where paa.assignment_id = l_assignment_id
2810: and paa.payroll_action_id = ppa.payroll_action_id
2811: and ppa.action_type in ('R', 'Q', 'V', 'B', 'I')
2816: and ppa.action_status = 'C';
2817:
2818: select ppa.payroll_id, paa.assignment_action_id, ptp.start_date
2819: into l_payroll_id, l_run_assact_id, p_lumpsum_date
2820: from pay_payroll_actions ppa
2821: , pay_assignment_actions paa
2822: , per_time_periods ptp
2823: where paa.assignment_id = l_assignment_id
2824: and paa.action_sequence = l_max_act_seq
4367: ) return varchar2 is
4368:
4369: start_ptr number;
4370: end_ptr number;
4371: token_val pay_payroll_actions.legislative_parameters%type;
4372: par_value pay_payroll_actions.legislative_parameters%type;
4373:
4374: begin
4375:
4368:
4369: start_ptr number;
4370: end_ptr number;
4371: token_val pay_payroll_actions.legislative_parameters%type;
4372: par_value pay_payroll_actions.legislative_parameters%type;
4373:
4374: begin
4375:
4376: token_val := name || '=';