148: (grade_name per_grades.name%type
149: ,position_name hr_all_positions_f.name%type
150: ,job_name per_jobs.name%type
151: ,payroll_name pay_all_payrolls_f.payroll_name%type
152: ,organization_name hr_all_organization_units.name%type
153: ,location_code hr_locations_all.location_code%type
154: ,pay_basis_name per_pay_bases.name%type
155: );
156:
426: ,c_business_group_id in number
427: ,c_effective_date in date
428: ) is
429: select htl.name
430: from hr_all_organization_units_tl htl
431: ,hr_all_organization_units hao
432: where hao.organization_id = c_organization_id
433: and hao.business_group_id = c_business_group_id
434: and htl.organization_id = hao.organization_id
427: ,c_effective_date in date
428: ) is
429: select htl.name
430: from hr_all_organization_units_tl htl
431: ,hr_all_organization_units hao
432: where hao.organization_id = c_organization_id
433: and hao.business_group_id = c_business_group_id
434: and htl.organization_id = hao.organization_id
435: and htl.language = Userenv('LANG')
1806: -- =============================================================================
1807: procedure Get_WrkStrs_Names is
1808: l_proc_name constant varchar2(150):= g_pkg ||'Get_WrkStrs_Names';
1809: l_pay_basis_name per_pay_bases.name%type;
1810: l_organization_name hr_all_organization_units.name%type;
1811: l_location_code hr_locations_all.location_code%type;
1812: l_payroll_name pay_all_payrolls_f.payroll_name%type;
1813: l_job_name per_jobs.name%type;
1814: l_position_name hr_all_positions_f.name%type;
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;
7473: l_payroll_name pay_payrolls_f.payroll_name%type;
7474: l_job_name per_jobs.name%type;
7475: l_position_name per_positions.name%type;
9716: l_party_id per_people_f.party_id%type;
9717: l_dff_ctx fnd_descr_flex_contexts.descriptive_flex_context_code%type;
9718:
9719: -- added by dbansal
9720: l_gre_name HR_ALL_ORGANIZATION_UNITS_TL.name%type;
9721: temp varchar2(20);
9722: --
9723: -- Date variables
9724: --