DBA Data[Home] [Help]

APPS.HR_DYNSQL dependencies on PAY_PROC_ENVIRONMENT_PKG

Line 1850: pay_proc_environment_pkg.pactid := pactid;

1846: ignore number;
1847: range_proc varchar2(60);
1848: statem varchar2(256);
1849: begin
1850: pay_proc_environment_pkg.pactid := pactid;
1851:
1852: select range_code
1853: into range_proc
1854: from pay_report_format_mappings_f prfm,

Line 2629: pay_proc_environment_pkg.pactid := pactid;

2625: action = PYG_AT_MAG or
2626: action = PYG_AT_PST or
2627: action = PYG_AT_CSH
2628: ) then
2629: pay_proc_environment_pkg.pactid := pactid;
2630: if (sqlid = PY_RESRGE) then
2631: sqlstr := ordrrsel_nohint || resact || --Modified here for Bug 13847750
2632: ' union all ' || orgsel || orgfrom ||
2633: orgorderby;

Line 3719: where pay_pac.payroll_action_id = pay_proc_environment_pkg.get_pactid()

3715: from
3716: pay_payroll_actions pay_pac,
3717: hr_organization_units hou,
3718: hr_organization_information hoi
3719: where pay_pac.payroll_action_id = pay_proc_environment_pkg.get_pactid()
3720: and hou.business_group_id = pay_pac.business_group_id
3721: and hoi.organization_id = hou.organization_id
3722: and hoi.org_information_context = ''CLASS''
3723: and hoi.org_information1 = ''HR_PAYEE''';