[Home] [Help]
1137:
1138: select effective_date,
1139: report_type,
1140: business_group_id,
1141: pycadar_pkg.get_parameter('PRE_ORGANIZATION_ID',
1142: legislative_parameters)
1143: into l_effective_date,
1144: l_report_type,
1145: l_bus_group_id,
2136: hr_organization_information hoi
2137: where paa.assignment_action_id = asgactid
2138: and ppa.payroll_action_id = paa.payroll_action_id
2139: and hoi.org_information2 =
2140: pycadar_pkg.get_parameter('PRE_ORGANIZATION_ID',
2141: ppa.legislative_parameters)
2142: and hoi.org_information_context = 'Canada Employer Identification'
2143: and hoi.org_information5 in ('T4/RL1','T4A/RL1')
2144: order by organization_id;
2151: hr_organization_information hoi
2152: where paa.assignment_action_id = asgactid
2153: and ppa.payroll_action_id = paa.payroll_action_id
2154: and hoi.org_information2 =
2155: pycadar_pkg.get_parameter('PRE_ORGANIZATION_ID',
2156: ppa.legislative_parameters)
2157: and hoi.org_information_context = 'Canada Employer Identification'
2158: and hoi.org_information5 in ('T4/RL1','T4A/RL1')
2159: order by organization_id;
2261: where arch_paa.assignment_action_id = cp_asgactid
2262: and arch_ppa.payroll_action_id = arch_paa.payroll_action_id
2263: and hou.business_group_id + 0 = arch_ppa.business_group_id
2264: and hou.organization_id = hoi.organization_id
2265: and hoi.org_information2 = pycadar_pkg.get_parameter('PRE_ORGANIZATION_ID',
2266: arch_ppa.legislative_parameters)
2267: and hoi.org_information_context = 'Canada Employer Identification'
2268: and run_paa.tax_unit_id = hou.organization_id
2269: and run_ppa.payroll_action_id = run_paa.payroll_action_id
2421:
2422: hr_utility.trace('eoy_archive_data archiving employer data');
2423: hr_utility.trace('l_payroll_action_id '|| to_char(l_payroll_action_id));
2424:
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
2529: WHERE hou.business_group_id = ppa.business_group_id
2530: and hoi.organization_id = hou.organization_id
2531: and hoi.org_information_context='Prov Reporting Est'
2532: and hoi.organization_id =
2533: pycadar_pkg.get_parameter('PRE_ORGANIZATION_ID',
2534: ppa.legislative_parameters )
2535: and ppa.payroll_action_id = l_payroll_action_id
2536: and hoi.org_information4 = 'P01';
2537:
4078: l_year_end date;
4079:
4080: begin
4081:
4082: select pycadar_pkg.get_parameter('PRE_ORGANIZATION_ID',
4083: legislative_parameters),
4084: trunc(effective_date,'Y'),
4085: effective_date,
4086: business_group_id