[Home] [Help]
306: RETURN varchar2
307: IS
308: start_ptr number;
309: end_ptr number;
310: token_val pay_payroll_actions.legislative_parameters%type;
311: par_value pay_payroll_actions.legislative_parameters%type;
312:
313: BEGIN
314:
307: IS
308: start_ptr number;
309: end_ptr number;
310: token_val pay_payroll_actions.legislative_parameters%type;
311: par_value pay_payroll_actions.legislative_parameters%type;
312:
313: BEGIN
314:
315: token_val := name||'=';
368: (select 'X'
369: from hr_organization_information mag,
370: hr_organization_information gre,
371: hr_all_organization_units hou,
372: pay_payroll_actions ppa
373: where hou.business_group_id = cp_business_group_id
374: and hou.organization_id = gre.organization_id
375: and gre.org_information_context = 'Canada Employer Identification'
376: and gre.organization_id = cp_gre_id
391: (select 'X'
392: from hr_organization_information mag,
393: hr_organization_information gre,
394: hr_all_organization_units hou,
395: pay_payroll_actions ppa
396: where hou.business_group_id = cp_business_group_id
397: and hou.organization_id = gre.organization_id
398: and gre.org_information_context = 'Canada Employer Identification'
399: and gre.organization_id = cp_gre_id
413: where exists
414: (select 'X'
415: from hr_organization_information pre,
416: hr_all_organization_units hou,
417: pay_payroll_actions ppa
418: where hou.business_group_id = cp_business_group_id
419: and hou.organization_id = pre.organization_id
420: and pre.org_information4 = 'P01'
421: and pre.org_information_context = 'Prov Reporting Est'
435: where exists
436: (select 'X'
437: from hr_organization_information pre,
438: hr_all_organization_units hou,
439: pay_payroll_actions ppa
440: where hou.business_group_id = cp_business_group_id
441: and hou.organization_id = pre.organization_id
442: and pre.org_information4 = 'P02'
443: and pre.org_information_context = 'Prov Reporting Est'
524: cp_effective_date date) is
525: select paa.assignment_action_id
526: from pay_assignment_actions paa,
527: per_all_assignments_f paf,
528: pay_payroll_actions ppa,
529: pay_action_classifications pac
530: where paf.person_id = cp_person_id
531: and paa.assignment_id = paf.assignment_id
532: and paa.tax_unit_id = cp_gre_id
546: and ppa.run_type_id is null
547: and paa.run_type_id is not null
548: and paa.source_action_id is null))
549: and not exists (select 1
550: from pay_payroll_actions ppa1,
551: pay_assignment_actions paa1
552: where ppa1.report_type = p_report_type
553: and ppa1.business_group_id+0 = p_bus_grp
554: and ppa1.effective_date = add_months(cp_effective_date, 12) - 1
562: /* Cursor to get details of payroll action of the Year End Pre-Process */
563: cursor get_yepp_payroll_action(cp_effective_date date,
564: cp_gre_id number) is
565: select payroll_action_id
566: from pay_payroll_actions
567: where action_type = 'X'
568: and action_status = 'C'
569: and report_type = p_report_type
570: and business_group_id+0 = p_bus_grp
590: ln_gross_earnings number(30);
591: ln_no_gross_earnings number(30);
592: l_assignment_id per_all_assignments_f.assignment_id%type;
593: l_person_id per_all_assignments_f.person_id%type;
594: l_yepp_payroll_action_id pay_payroll_actions.payroll_action_id%type;
595: lockingactid pay_assignment_actions.assignment_action_id%type;
596: l_prev_person_id per_all_assignments_f.person_id%type;
597:
598: BEGIN
820: select paa.assignment_action_id
821: from pay_assignment_actions paa,
822: per_all_assignments_f paf,
823: per_all_people_f ppf,
824: pay_payroll_actions ppa,
825: pay_action_classifications pac
826: where ppf.person_id = cp_person_id
827: and paf.person_id = ppf.person_id
828: and paa.assignment_id = paf.assignment_id
837: and add_months(cp_effective_date, 12) - 1
838: and ppa.action_type = pac.action_type
839: and pac.classification_name = 'SEQUENCED'
840: and not exists (select 1
841: from pay_payroll_actions ppa1,
842: pay_assignment_actions paa1
843: where ppa1.report_type = p_report_type
844: and ppa1.business_group_id+0 = p_bus_grp
845: and ppa1.effective_date = add_months(cp_effective_date, 12) - 1
852:
853: cursor get_yepp_payroll_action(cp_effective_date date,
854: cp_pre_id number) is
855: select payroll_action_id
856: from pay_payroll_actions
857: where action_type = 'X'
858: and action_status = 'C'
859: and report_type = p_report_type
860: and business_group_id+0 = p_bus_grp
881: ln_no_gross_earnings number(30);
882: l_assignment_id per_all_assignments_f.assignment_id%type;
883: l_person_id per_all_assignments_f.person_id%type;
884: l_prev_person_id per_all_assignments_f.person_id%type;
885: l_yepp_payroll_action_id pay_payroll_actions.payroll_action_id%type;
886: lockingactid pay_assignment_actions.assignment_action_id%type;
887: l_tax_unit_id pay_assignment_actions.tax_unit_id%type;
888:
889: BEGIN
1065: and paf.business_group_id+0 = p_bus_grp
1066: and paf.effective_start_date <= add_months(cp_effective_date, 12) - 1
1067: and paf.effective_end_date >= cp_effective_date
1068: and exists (select 1
1069: from pay_payroll_actions ppa1,
1070: pay_assignment_actions paa1
1071: where ppa1.report_type = p_report_type
1072: and ppa1.business_group_id+0 = p_bus_grp
1073: and ppa1.effective_date = add_months(cp_effective_date, 12) - 1
1090: and paf.business_group_id+0 = p_bus_grp
1091: and paf.effective_start_date <= add_months(cp_effective_date, 12) - 1
1092: and paf.effective_end_date >= cp_effective_date
1093: and exists (select 1
1094: from pay_payroll_actions ppa1,
1095: pay_assignment_actions paa1
1096: where ppa1.report_type = p_report_type
1097: and ppa1.business_group_id+0 = p_bus_grp
1098: and ppa1.effective_date = add_months(cp_effective_date, 12) - 1
1186: select distinct has.assignment_id
1187: from hr_assignment_set_amendments has,
1188: per_all_assignments_f paf,
1189: pay_assignment_actions paa,
1190: pay_payroll_actions ppa
1191: where has.assignment_set_id = cp_assignment_set_id
1192: and paf.assignment_id = has.assignment_id
1193: and nvl(has.include_or_exclude,'I') = 'I'
1194: and paf.effective_start_date <= add_months(cp_effective_date, 12) - 1
1353: select distinct has.assignment_id
1354: from hr_assignment_set_amendments has,
1355: per_all_assignments_f paf,
1356: pay_assignment_actions paa,
1357: pay_payroll_actions ppa
1358: where has.assignment_set_id = cp_assignment_set_id
1359: and paf.assignment_id = has.assignment_id
1360: and nvl(has.include_or_exclude,'I') = 'I'
1361: and paf.effective_start_date <= add_months(cp_effective_date, 12) - 1
1377: select distinct has.assignment_id
1378: from hr_assignment_set_amendments has,
1379: per_all_assignments_f paf,
1380: pay_assignment_actions paa,
1381: pay_payroll_actions ppa
1382: where has.assignment_set_id = cp_assignment_set_id
1383: and paf.assignment_id = has.assignment_id
1384: and nvl(has.include_or_exclude,'I') = 'I'
1385: and paf.effective_start_date <= add_months(cp_effective_date, 12) - 1
1540: paa.tax_unit_id
1541: from hr_assignment_set_amendments has,
1542: per_all_assignments_f paf,
1543: pay_assignment_actions paa,
1544: pay_payroll_actions ppa
1545: where has.assignment_set_id = cp_assignment_set_id
1546: and paf.assignment_id = has.assignment_id
1547: and nvl(has.include_or_exclude,'I') = 'I'
1548: and paf.effective_start_date <= add_months(cp_effective_date, 12) - 1
1564: hoi.org_information2
1565: from hr_assignment_set_amendments has,
1566: per_all_assignments_f paf,
1567: pay_assignment_actions paa,
1568: pay_payroll_actions ppa,
1569: hr_organization_information hoi
1570: where has.assignment_set_id = cp_assignment_set_id
1571: and paf.assignment_id = has.assignment_id
1572: and nvl(has.include_or_exclude,'I') = 'I'