APPS.PQP_PERASGADD_RIW dependencies on HR_API_MODULES

Line 7355: from hr_api_modules

7351: -- DP interface tables
7352: cursor csr_get_dp_mode (c_batch_id in number
7353: ,c_link_value in number) is
7354: select 'CREATE'
7355: from hr_api_modules
7356: where module_name = 'CREATE_EMPLOYEE'
7357: and module_package = 'HR_EMPLOYEE_API'
7358: and api_module_id in (select api_module_id
7359: from hr_pump_batch_lines

Line 7368: ,hr_api_modules ham

7364: cursor csr_get_api_names (c_batch_id in number
7365: ,c_link_value in number) is
7366: select module_name
7367: from hr_pump_batch_lines hpbl
7368: ,hr_api_modules ham
7369: where batch_id = c_batch_id
7370: and link_value = c_link_value
7371: and line_status in ('U', 'E')
7372: and hpbl.api_module_id = ham.api_module_id;

Line 7468: l_api_name hr_api_modules.module_name%type;

7464: l_proc_name constant varchar2(150):= g_pkg ||'HR_DataPumpErr';
7465:
7466: l_dp_mode varchar2(40);
7467: l_if_end_dated varchar2(20);
7468: l_api_name hr_api_modules.module_name%type;
7469: l_user_person_type per_person_types.user_person_type%type;
7470: l_pay_basis_name per_pay_bases.name%type;
7471: l_organization_name hr_all_organization_units.name%type;
7472: l_location_code hr_locations_all.location_code%type;