[Home] [Help]
956: /* Variables used to hold the details of the payroll and assignment actions
957: that are created. */
958:
959: l_payroll_action_created boolean := false;
960: l_payroll_action_id pay_payroll_actions.payroll_action_id%type;
961: l_assignment_action_id pay_assignment_actions.assignment_action_id%type;
962: l_archive_item_id number;
963:
964: /* Variable holding the balance to be tested. */
989: l_jurisdiction_code varchar2(30);
990:
991: /* general process variables */
992:
993: l_report_type pay_payroll_actions.report_type%type;
994: l_province pay_payroll_actions.report_qualifier%type;
995: l_value number;
996: l_effective_date date;
997: l_quarter_start date;
990:
991: /* general process variables */
992:
993: l_report_type pay_payroll_actions.report_type%type;
994: l_province pay_payroll_actions.report_qualifier%type;
995: l_value number;
996: l_effective_date date;
997: l_quarter_start date;
998: l_quarter_end date;
1056: asg.assignment_id assignment_id,
1057: asg.effective_end_date effective_end_date
1058: FROM per_all_assignments_f asg,
1059: pay_assignment_actions paa,
1060: pay_payroll_actions ppa
1061: WHERE ppa.effective_date between l_period_start
1062: and l_period_end
1063: AND ppa.action_type in ('R','Q','V','B','I')
1064: AND ppa.business_group_id +0 = l_bus_group_id
1111: select paa.assignment_action_id
1112: from pay_assignment_actions paa,
1113: per_all_assignments_f paf,
1114: per_all_people_f ppf,
1115: pay_payroll_actions ppa,
1116: pay_action_classifications pac
1117: where ppf.person_id = cp_person_id
1118: and paf.person_id = ppf.person_id
1119: and paa.assignment_id = paf.assignment_id
1143: into l_effective_date,
1144: l_report_type,
1145: l_bus_group_id,
1146: l_pre_organization_id
1147: from pay_payroll_actions
1148: where payroll_action_id = pactid;
1149:
1150: hr_utility.trace('getting dates');
1151:
1531: /*hr_utility.trace_on('Y','RL1'); */
1532:
1533: select to_char(effective_date,'YYYY'),business_group_id
1534: into l_taxation_year,l_business_group_id
1535: from pay_payroll_actions
1536: where payroll_action_id = p_payroll_action_id;
1537:
1538: open employer_info;
1539:
2130:
2131: cursor c_all_gres(asgactid number) is
2132: select hoi.organization_id ,
2133: hoi.org_information5
2134: from pay_payroll_actions ppa,
2135: pay_assignment_actions paa,
2136: hr_organization_information hoi
2137: where paa.assignment_action_id = asgactid
2138: and ppa.payroll_action_id = paa.payroll_action_id
2145:
2146: cursor c_all_gres_for_footnote(asgactid number) is
2147: select hoi.organization_id ,
2148: hoi.org_information5
2149: from pay_payroll_actions ppa,
2150: pay_assignment_actions paa,
2151: hr_organization_information hoi
2152: where paa.assignment_action_id = asgactid
2153: and ppa.payroll_action_id = paa.payroll_action_id
2167: */
2168: cursor c_all_gres_for_person(cp_asg_id number,cp_eff_date date) is
2169: select distinct paa.tax_unit_id
2170: from pay_assignment_actions paa,
2171: pay_payroll_actions ppa,
2172: per_all_assignments_f paf
2173: where paa.assignment_id = cp_asg_id
2174: and paf.assignment_id = cp_asg_id
2175: and paf.assignment_id = paa.assignment_id
2250: , pay_element_types_f pet
2251: , pay_input_values_f piv1
2252: , pay_input_values_f piv2
2253: , pay_assignment_actions run_paa
2254: , pay_payroll_actions run_ppa
2255: , pay_assignment_actions arch_paa
2256: , pay_payroll_actions arch_ppa
2257: , per_all_assignments_f arch_paf
2258: , per_all_assignments_f all_paf
2252: , pay_input_values_f piv2
2253: , pay_assignment_actions run_paa
2254: , pay_payroll_actions run_ppa
2255: , pay_assignment_actions arch_paa
2256: , pay_payroll_actions arch_ppa
2257: , per_all_assignments_f arch_paf
2258: , per_all_assignments_f all_paf
2259: , hr_all_organization_units hou
2260: , hr_organization_information hoi
2308: and fdi.user_name = 'CAEOY_RL1_PROVINCE_OF_EMPLOYMENT';
2309:
2310: CURSOR c_get_fapp_lkd_actid_rtype(cp_locked_actid number) IS
2311: select ppa.report_type
2312: from pay_payroll_actions ppa,pay_assignment_actions paa
2313: where paa.assignment_action_id = cp_locked_actid
2314: and ppa.payroll_action_id = paa.payroll_action_id;
2315:
2316: CURSOR c_get_fapp_locked_action_id(cp_locking_act_id number) IS
2338: select paa.assignment_action_id
2339: from pay_assignment_actions paa,
2340: per_all_assignments_f paf,
2341: per_all_people_f ppf,
2342: pay_payroll_actions ppa,
2343: pay_action_classifications pac,
2344: pay_action_contexts pac1,
2345: ff_contexts fc
2346: where ppf.person_id = cp_person_id
2370: select paa.assignment_action_id
2371: from pay_assignment_actions paa,
2372: per_all_assignments_f paf,
2373: per_all_people_f ppf,
2374: pay_payroll_actions ppa,
2375: pay_action_classifications pac
2376: where ppf.person_id = cp_person_id
2377: and paf.person_id = ppf.person_id
2378: and paf.assignment_id = paa.assignment_id
2425: select pycadar_pkg.get_parameter('PRE_ORGANIZATION_ID',
2426: legislative_parameters),
2427: business_group_id
2428: into l_pre_organization_id,l_business_group_id
2429: from pay_payroll_actions
2430: where payroll_action_id = l_payroll_action_id;
2431:
2432: eoy_archive_gre_data(p_payroll_action_id =>l_payroll_action_id,
2433: p_pre_organization_id=>l_pre_organization_id);
2522:
2523: select decode(hoi.org_information3,'Y',hoi.organization_id,
2524: hoi.org_information20)
2525: into l_transmitter_name1
2526: from pay_payroll_actions ppa,
2527: hr_organization_information hoi,
2528: hr_all_organization_units hou
2529: WHERE hou.business_group_id = ppa.business_group_id
2530: and hoi.organization_id = hou.organization_id
3933: ,legislative_parameters))
3934: into lv_fapp_effective_date,
3935: lv_fapp_report_type,
3936: ln_fapp_pre_org_id
3937: from pay_payroll_actions
3938: where payroll_action_id = l_payroll_action_id;
3939:
3940: hr_utility.trace('Prov Amend Pre-Process Pactid :'||
3941: to_char(l_payroll_action_id));
4087: into l_pre_organization_id,
4088: l_year_start,
4089: l_year_end,
4090: l_business_group
4091: from pay_payroll_actions
4092: where payroll_action_id = pactid;
4093:
4094: sqlstr := 'select distinct asg.person_id
4095: from pay_all_payrolls_f ppy,
4092: where payroll_action_id = pactid;
4093:
4094: sqlstr := 'select distinct asg.person_id
4095: from pay_all_payrolls_f ppy,
4096: pay_payroll_actions ppa,
4097: pay_assignment_actions paa,
4098: per_all_assignments_f asg,
4099: pay_payroll_actions ppa1
4100: where ppa1.payroll_action_id = :payroll_action_id
4095: from pay_all_payrolls_f ppy,
4096: pay_payroll_actions ppa,
4097: pay_assignment_actions paa,
4098: per_all_assignments_f asg,
4099: pay_payroll_actions ppa1
4100: where ppa1.payroll_action_id = :payroll_action_id
4101: and ppa.effective_date between
4102: fnd_date.canonical_to_date('''||
4103: fnd_date.date_to_canonical(l_year_start)||''') and