[Home] [Help]
76: to_char(effective_date,'YYYY') ,
77: effective_date,
78: start_date,
79: business_group_id
80: from pay_payroll_actions ppa
81: where ppa.payroll_action_id = cp_payroll_action_id;
82:
83: ld_end_date DATE;
84: ld_start_date DATE;
158: report_type,
159: report_qualifier,
160: report_category
161: -- Added for bug 10399514
162: from pay_payroll_actions ppa
163: where ppa.payroll_action_id = cp_payroll_action_id;
164:
165: ld_end_date DATE;
166: ld_start_date DATE;
169: ln_person_id NUMBER := 0;
170: ln_asg_set NUMBER := 0;
171: lv_sin per_all_people_f.national_identifier%TYPE;
172: lv_year VARCHAR2(4);
173: lv_report_type1 pay_payroll_actions.report_type%TYPE;
174: lv_state1 pay_payroll_actions.report_qualifier%type;
175: lv_report_cat1 pay_report_format_mappings_f.report_format%type;
176:
177: BEGIN
170: ln_asg_set NUMBER := 0;
171: lv_sin per_all_people_f.national_identifier%TYPE;
172: lv_year VARCHAR2(4);
173: lv_report_type1 pay_payroll_actions.report_type%TYPE;
174: lv_state1 pay_payroll_actions.report_qualifier%type;
175: lv_report_cat1 pay_report_format_mappings_f.report_format%type;
176:
177: BEGIN
178: hr_utility.trace('Entered get_payroll_action_info');
351: ln_asg_set NUMBER := 0 ;
352: ln_prev_asg_action_id NUMBER := 0;
353: ln_prev_assignment_id NUMBER := 0;
354: ld_prev_effective_date DATE ;
355: lv_report_type pay_payroll_actions.report_type%TYPE ;
356: ln_asg_act_to_lock pay_assignment_actions.assignment_action_id%TYPE;
357:
358:
359: lv_serial_number VARCHAR2(30);
365: lv_record_name varchar2(80);
366:
367: -- Variables declared for bug 10399514
368: lv_person_on boolean ;
369: lv_report_cat pay_payroll_actions.report_category%type;
370: lv_state pay_payroll_actions.report_qualifier%type;
371: lv_report_format pay_report_format_mappings_f.report_format%type;
372: -- Variables declared for bug 10399514
373:
366:
367: -- Variables declared for bug 10399514
368: lv_person_on boolean ;
369: lv_report_cat pay_payroll_actions.report_category%type;
370: lv_state pay_payroll_actions.report_qualifier%type;
371: lv_report_format pay_report_format_mappings_f.report_format%type;
372: -- Variables declared for bug 10399514
373:
374: CURSOR c_selected_asg_set(cp_start_person in number
377: select distinct paf.person_id
378: from hr_assignment_set_amendments asgset,
379: per_all_assignments_f paf,
380: pay_assignment_actions paa,
381: pay_payroll_actions ppa
382: where
383: (pay_ca_eoy_rl2_amend_arch.get_parameter('PRE_ORGANIZATION_ID',
384: ppa.legislative_parameters) = to_char(ln_pre_org_id)
385: OR pay_ca_eoy_rl2_amend_arch.get_parameter('TRANSMITTER_PRE',
406: select distinct paf.person_id
407: from hr_assignment_set_amendments asgset,
408: per_all_assignments_f paf,
409: pay_assignment_actions paa,
410: pay_payroll_actions ppa,
411: pay_population_ranges ppr
412: where
413: (pay_ca_eoy_rl2_amend_arch.get_parameter('PRE_ORGANIZATION_ID',
414: ppa.legislative_parameters) = to_char(ln_pre_org_id)
442: report_qualifier,
443: report_category,
444: -- Added for bug 10399514
445: paa.assignment_action_id
446: from pay_payroll_actions ppa,
447: pay_assignment_actions paa
448: where (pay_ca_eoy_rl2_amend_arch.get_parameter('PRE_ORGANIZATION_ID',
449: ppa.legislative_parameters) = to_char(ln_pre_org_id)
450: OR pay_ca_eoy_rl2_amend_arch.get_parameter('TRANSMITTER_PRE',
684: parameter_list varchar2) return varchar2
685: is
686: start_ptr number;
687: end_ptr number;
688: token_val pay_payroll_actions.legislative_parameters%type;
689: par_value pay_payroll_actions.legislative_parameters%type;
690: begin
691:
692: token_val := name||'=';
685: is
686: start_ptr number;
687: end_ptr number;
688: token_val pay_payroll_actions.legislative_parameters%type;
689: par_value pay_payroll_actions.legislative_parameters%type;
690: begin
691:
692: token_val := name||'=';
693: