DBA Data[Home] [Help]

APPS.HR_DYNSQL dependencies on PAY_PROC_ENVIRONMENT_PKG

Line 1815: pay_proc_environment_pkg.pactid := pactid;

1811: ignore number;
1812: range_proc varchar2(60);
1813: statem varchar2(256);
1814: begin
1815: pay_proc_environment_pkg.pactid := pactid;
1816:
1817: select range_code
1818: into range_proc
1819: from pay_report_format_mappings_f prfm,

Line 2571: pay_proc_environment_pkg.pactid := pactid;

2567: action = PYG_AT_MAG or
2568: action = PYG_AT_PST or
2569: action = PYG_AT_CSH
2570: ) then
2571: pay_proc_environment_pkg.pactid := pactid;
2572: if (sqlid = PY_RESRGE) then
2573: sqlstr := ordrrsel || resact ||
2574: ' union all ' || orgsel || orgfrom ||
2575: orgorderby;

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

3596: from
3597: pay_payroll_actions pay_pac,
3598: hr_organization_units hou,
3599: hr_organization_information hoi
3600: where pay_pac.payroll_action_id = pay_proc_environment_pkg.get_pactid()
3601: and hou.business_group_id = pay_pac.business_group_id
3602: and hoi.organization_id = hou.organization_id
3603: and hoi.org_information_context = ''CLASS''
3604: and hoi.org_information1 = ''HR_PAYEE''';