[Home] [Help]
96: business_group_id,
97: pay_ca_eoy_t4_amend_reg.get_parameter(
98: 'PROV_CD',ppa.legislative_parameters),
99: report_type
100: from pay_payroll_actions ppa
101: where ppa.payroll_action_id = cp_payroll_action_id;
102:
103: ld_end_date DATE;
104: ld_start_date DATE;
227: elsif ln_tax_unit_id is not NULL then
228:
229: lv_sql_string :=
230: 'select distinct paf.person_id
231: from pay_payroll_actions ppa_arch,
232: pay_assignment_actions paa_arch,
233: per_assignments_f paf,
234: pay_payroll_actions ppa
235: where paa_arch.assignment_id = paf.assignment_id
230: 'select distinct paf.person_id
231: from pay_payroll_actions ppa_arch,
232: pay_assignment_actions paa_arch,
233: per_assignments_f paf,
234: pay_payroll_actions ppa
235: where paa_arch.assignment_id = paf.assignment_id
236: and ppa.payroll_action_id = :payroll_action_id
237: and ppa_arch.business_group_id = ppa.business_group_id
238: and ppa_arch.effective_date = ppa.effective_date
245: else
246:
247: lv_sql_string :=
248: 'select distinct paf.person_id
249: from pay_payroll_actions ppa_arch,
250: pay_assignment_actions paa_arch,
251: per_assignments_f paf,
252: pay_payroll_actions ppa
253: where paa_arch.assignment_id = paf.assignment_id
248: 'select distinct paf.person_id
249: from pay_payroll_actions ppa_arch,
250: pay_assignment_actions paa_arch,
251: per_assignments_f paf,
252: pay_payroll_actions ppa
253: where paa_arch.assignment_id = paf.assignment_id
254: and ppa.payroll_action_id = :payroll_action_id
255: and ppa_arch.business_group_id = ppa.business_group_id
256: and ppa_arch.effective_date = ppa.effective_date
304: ln_asg_set NUMBER := 0 ;
305: lv_print varchar2(10);
306: lv_prov_cd varchar2(5);
307:
308: lv_report_type pay_payroll_actions.report_type%TYPE ;
309: ln_asg_act_to_lock pay_assignment_actions.assignment_action_id%TYPE;
310: ln_second_last_arch_action pay_assignment_actions.assignment_action_id%TYPE;
311: ln_prev_yepp_lock_action pay_assignment_actions.assignment_action_id%TYPE;
312:
315: lv_employee_number per_people_f.employee_number%type;
316: lv_message varchar2(100):= null;
317: lv_full_name per_people_f.full_name%type;
318: lv_record_name varchar2(100);
319: lv_prev_report_type pay_payroll_actions.report_type%TYPE;
320: ln_prev_lock_action pay_assignment_actions.assignment_action_id%TYPE;
321: ln_prev_w2c_action_id pay_assignment_actions.assignment_action_id%TYPE;
322: ln_serial_number pay_assignment_actions.serial_number%TYPE;
323: ln_gre_id NUMBER;
330: ,cp_effective_date in date) is
331: select distinct paf.person_id
332: from hr_assignment_set_amendments asgset,
333: per_assignments_f paf,
334: pay_payroll_actions ppa,
335: pay_assignment_actions paa
336: where asgset.assignment_set_id = cp_asg_set
337: and asgset.include_or_exclude = 'I'
338: and paf.assignment_id = asgset.assignment_id
360: >= cp_eff_date
361: AND hoi.org_information_context = 'Canada Employer Identification'
362: AND hoi.org_information5 = 'T4/RL1'
363: AND exists ( SELECT 1
364: FROM pay_payroll_actions ppa ,
365: pay_assignment_actions paa
366: WHERE ppa.report_type = 'CAEOY_T4_AMEND_PP'
367: AND ppa.report_qualifier = 'CAEOY_T4_AMEND_PPQ'
368: AND ppa.business_group_id = cp_bg_id
375: cp_eff_date date,
376: cp_start_person number,
377: cp_end_person number) is
378: select distinct paa_arch.serial_number
379: from pay_payroll_actions ppa_arch,
380: pay_assignment_actions paa_arch
381: where ppa_arch.business_group_id = cp_bg_id
382: and ppa_arch.report_type = 'CAEOY_T4_AMEND_PP'
383: AND ppa_arch.report_qualifier = 'CAEOY_T4_AMEND_PPQ'
400: select ppa.report_type,
401: paa.assignment_id,
402: paa.assignment_action_id,
403: paa.tax_unit_id
404: from pay_payroll_actions ppa,
405: pay_assignment_actions paa
406: where paa.serial_number = to_char(cp_person_id)
407: and paa.tax_unit_id = nvl(cp_tax_unit_id,paa.tax_unit_id)
408: and ppa.business_group_id = ln_business_group_id
426: select ppa.report_type,
427: paa.assignment_id,
428: paa.assignment_action_id,
429: paa.tax_unit_id
430: from pay_payroll_actions ppa,
431: pay_assignment_actions paa
432: where paa.serial_number = to_char(cp_person_id)
433: and paa.tax_unit_id = nvl(cp_tax_unit_id,paa.tax_unit_id)
434: and ppa.business_group_id = ln_business_group_id
447: CURSOR get_yepp_pact_id(cp_bg_id number,
448: cp_gre number,
449: cp_year date) IS
450: select payroll_action_id
451: from pay_payroll_actions
452: where business_group_id = cp_bg_id
453: and report_type = 'T4'
454: and report_qualifier = 'CAEOY'
455: and action_type = 'X'
879: l_year_start date;
880: l_year_end date;
881: l_print varchar2(20);
882: l_asg_set_id hr_assignment_set_amendments.assignment_set_id%TYPE;
883: l_bg_id pay_payroll_actions.business_group_id%type ;
884:
885: begin
886:
887: begin
906: l_print,
907: l_year_end,
908: l_year_start,
909: l_bg_id
910: from pay_payroll_actions ppa
911: where ppa.payroll_action_id = payactid;
912:
913: exception when no_data_found then
914: hr_utility.trace('Error in Sort Procedure - getting legislative param');
928: hr_locations_all loc,
929: per_all_people_f ppf,
930: per_all_assignments_f paf,
931: pay_assignment_actions paa1,
932: pay_payroll_actions ppa1
933: where ppa1.payroll_action_id = :p_payroll_action_id
934: and paa1.payroll_action_id = ppa1.payroll_action_id
935: and paa1.assignment_id = paf.assignment_id
936: and paf.effective_start_date =
979: parameter_list varchar2) return varchar2
980: IS
981: start_ptr number;
982: end_ptr number;
983: token_val pay_payroll_actions.legislative_parameters%type;
984: par_value pay_payroll_actions.legislative_parameters%type;
985:
986: BEGIN
987:
980: IS
981: start_ptr number;
982: end_ptr number;
983: token_val pay_payroll_actions.legislative_parameters%type;
984: par_value pay_payroll_actions.legislative_parameters%type;
985:
986: BEGIN
987:
988: token_val := name||'=';