[Home] [Help]
1277: report_qualifier,
1278: report_category,
1279: -- Added for bug 10399514
1280: business_group_id,
1281: pycadar_pkg.get_parameter('PRE_ORGANIZATION_ID',
1282: legislative_parameters)
1283: into l_effective_date,
1284: l_report_type,
1285: -- Added for bug 10399514
2339: WHERE hou.business_group_id = ppa.business_group_id
2340: and hoi.organization_id = hou.organization_id
2341: and hoi.org_information_context='Prov Reporting Est'
2342: and hoi.organization_id =
2343: pycadar_pkg.get_parameter('PRE_ORGANIZATION_ID',
2344: ppa.legislative_parameters )
2345: and ppa.payroll_action_id = p_payroll_action_id
2346: and hoi.org_information4 = 'P01';
2347:
2497: hr_organization_information hoi
2498: where paa.assignment_action_id = asgactid
2499: and ppa.payroll_action_id = paa.payroll_action_id
2500: and hoi.org_information2 =
2501: pycadar_pkg.get_parameter('PRE_ORGANIZATION_ID',
2502: ppa.legislative_parameters)
2503: and hoi.org_information_context = 'Canada Employer Identification'
2504: and hoi.org_information5 in ('T4/RL1','T4A/RL1')
2505: order by organization_id;
2958: hr_organization_information hoi
2959: where paa.assignment_action_id = asgactid
2960: and ppa.payroll_action_id = paa.payroll_action_id
2961: and hoi.org_information2 =
2962: pycadar_pkg.get_parameter('PRE_ORGANIZATION_ID',
2963: ppa.legislative_parameters)
2964: and hoi.org_information_context = 'Canada Employer Identification'
2965: and hoi.org_information5 in ('T4/RL1','T4A/RL1')
2966: order by organization_id;
2973: hr_organization_information hoi
2974: where paa.assignment_action_id = asgactid
2975: and ppa.payroll_action_id = paa.payroll_action_id
2976: and hoi.org_information2 =
2977: pycadar_pkg.get_parameter('PRE_ORGANIZATION_ID',
2978: ppa.legislative_parameters)
2979: and hoi.org_information_context = 'Canada Employer Identification'
2980: and hoi.org_information5 in ('T4/RL1','T4A/RL1')
2981: order by organization_id;
3084: where arch_paa.assignment_action_id = cp_asgactid
3085: and arch_ppa.payroll_action_id = arch_paa.payroll_action_id
3086: and hou.business_group_id + 0 = arch_ppa.business_group_id
3087: and hou.organization_id = hoi.organization_id
3088: and hoi.org_information2 = pycadar_pkg.get_parameter('PRE_ORGANIZATION_ID',
3089: arch_ppa.legislative_parameters)
3090: and hoi.org_information_context = 'Canada Employer Identification'
3091: and run_paa.assignment_id = arch_paa.assignment_id
3092: and run_paa.tax_unit_id = hou.organization_id
3265:
3266: hr_utility.trace('eoy_archive_data archiving employer data');
3267: hr_utility.trace('l_payroll_action_id '|| to_char(l_payroll_action_id));
3268:
3269: select pycadar_pkg.get_parameter('PRE_ORGANIZATION_ID',
3270: legislative_parameters),
3271: business_group_id
3272: into l_pre_organization_id,l_business_group_id
3273: from pay_payroll_actions
5103: l_year_end date;
5104:
5105: begin
5106:
5107: select pycadar_pkg.get_parameter('PRE_ORGANIZATION_ID',
5108: legislative_parameters),
5109: trunc(effective_date,'Y'),
5110: effective_date,
5111: business_group_id