DBA Data[Home] [Help]

APPS.PAY_CA_T4AEOY_ARCHIVE dependencies on PYCADAR_PKG

Line 611: l_eoy_tax_unit_id := pycadar_pkg.get_parameter('TRANSFER_GRE',l_legislative_parameters);

607: l_legislative_parameters
608: from pay_payroll_actions
609: where payroll_action_id = pactid;
610:
611: l_eoy_tax_unit_id := pycadar_pkg.get_parameter('TRANSFER_GRE',l_legislative_parameters);
612:
613: hr_utility.trace('getting dates');
614:
615: get_dates(l_report_type,

Line 1910: to_number(pycadar_pkg.get_parameter('TRANSFER_GRE',arch_ppa.legislative_parameters))

1906: and arch_ppa.payroll_action_id = arch_paa.payroll_action_id
1907: and hou.business_group_id = arch_ppa.business_group_id
1908: and hou.organization_id = hoi.organization_id
1909: and hoi.organization_id =
1910: to_number(pycadar_pkg.get_parameter('TRANSFER_GRE',arch_ppa.legislative_parameters))
1911: and hoi.org_information_context = 'Canada Employer Identification'
1912: and hoi.org_information5 IN ('T4A/RL1','T4A/RL2')
1913: and run_paa.tax_unit_id = hou.organization_id
1914: and run_ppa.payroll_action_id = run_paa.payroll_action_id

Line 3771: l_eoy_tax_unit_id := pycadar_pkg.get_parameter('TRANSFER_GRE',l_legislative_parameters);

3767: where payroll_action_id = pactid;
3768:
3769: hr_utility.trace('legislative prameter is '|| l_legislative_parameters);
3770:
3771: l_eoy_tax_unit_id := pycadar_pkg.get_parameter('TRANSFER_GRE',l_legislative_parameters);
3772:
3773: select org_information11
3774: into l_transmitter_gre_id
3775: from hr_organization_information