[Home] [Help]
732: l_legislative_parameters
733: from pay_payroll_actions
734: where payroll_action_id = pactid;
735:
736: l_eoy_tax_unit_id := pycadar_pkg.get_parameter('TRANSFER_GRE',l_legislative_parameters);
737:
738: hr_utility.trace('getting dates');
739:
740: get_dates(l_report_type,
2037: and arch_ppa.payroll_action_id = arch_paa.payroll_action_id
2038: and hou.business_group_id = arch_ppa.business_group_id
2039: and hou.organization_id = hoi.organization_id
2040: and hoi.organization_id =
2041: to_number(pycadar_pkg.get_parameter('TRANSFER_GRE',arch_ppa.legislative_parameters))
2042: and hoi.org_information_context = 'Canada Employer Identification'
2043: and hoi.org_information5 IN ('T4A/RL1','T4A/RL2')
2044: and run_paa.tax_unit_id = hou.organization_id
2045: and run_ppa.payroll_action_id = run_paa.payroll_action_id
3450: and arch_ppa.payroll_action_id = arch_paa.payroll_action_id
3451: and hou.business_group_id = arch_ppa.business_group_id
3452: and hou.organization_id = hoi.organization_id
3453: and hoi.organization_id =
3454: to_number(pycadar_pkg.get_parameter('TRANSFER_GRE',arch_ppa.legislative_parameters))
3455: and hoi.org_information_context = 'Canada Employer Identification'
3456: and hoi.org_information5 IN ('T4A/RL1','T4A/RL2')
3457: and run_paa.tax_unit_id = hou.organization_id
3458: and run_ppa.payroll_action_id = run_paa.payroll_action_id
5466: where payroll_action_id = pactid;
5467:
5468: hr_utility.trace('legislative prameter is '|| l_legislative_parameters);
5469:
5470: l_eoy_tax_unit_id := pycadar_pkg.get_parameter('TRANSFER_GRE',l_legislative_parameters);
5471:
5472: select org_information11
5473: into l_transmitter_gre_id
5474: from hr_organization_information