APPS.PQP_PERASGADD_RIW dependencies on HR_ALL_ORGANIZATION_UNITS

Line 153: ,organization_name hr_all_organization_units.name%type

149: (grade_name per_grades.name%type
150: ,position_name hr_all_positions_f.name%type
151: ,job_name per_jobs.name%type
152: ,payroll_name pay_all_payrolls_f.payroll_name%type
153: ,organization_name hr_all_organization_units.name%type
154: ,location_code hr_locations_all.location_code%type
155: ,pay_basis_name per_pay_bases.name%type
156: );
157:

Line 431: from hr_all_organization_units_tl htl

427: ,c_business_group_id in number
428: ,c_effective_date in date
429: ) is
430: select htl.name
431: from hr_all_organization_units_tl htl
432: ,hr_all_organization_units hao
433: where hao.organization_id = c_organization_id
434: and hao.business_group_id = c_business_group_id
435: and htl.organization_id = hao.organization_id

Line 432: ,hr_all_organization_units hao

428: ,c_effective_date in date
429: ) is
430: select htl.name
431: from hr_all_organization_units_tl htl
432: ,hr_all_organization_units hao
433: where hao.organization_id = c_organization_id
434: and hao.business_group_id = c_business_group_id
435: and htl.organization_id = hao.organization_id
436: and htl.language = Userenv('LANG')

Line 1912: l_organization_name hr_all_organization_units.name%type;

1908: -- =============================================================================
1909: procedure Get_WrkStrs_Names is
1910: l_proc_name constant varchar2(150):= g_pkg ||'Get_WrkStrs_Names';
1911: l_pay_basis_name per_pay_bases.name%type;
1912: l_organization_name hr_all_organization_units.name%type;
1913: l_location_code hr_locations_all.location_code%type;
1914: l_payroll_name pay_all_payrolls_f.payroll_name%type;
1915: l_job_name per_jobs.name%type;
1916: l_position_name hr_all_positions_f.name%type;

Line 7875: l_organization_name hr_all_organization_units.name%type;

7871: l_if_end_dated varchar2(20);
7872: l_api_name hr_api_modules.module_name%type;
7873: l_user_person_type per_person_types.user_person_type%type;
7874: l_pay_basis_name per_pay_bases.name%type;
7875: l_organization_name hr_all_organization_units.name%type;
7876: l_location_code hr_locations_all.location_code%type;
7877: l_payroll_name pay_payrolls_f.payroll_name%type;
7878: l_job_name per_jobs.name%type;
7879: l_position_name per_positions.name%type;

Line 10377: l_gre_name HR_ALL_ORGANIZATION_UNITS_TL.name%type;

10373: l_party_id per_people_f.party_id%type;
10374: l_dff_ctx fnd_descr_flex_contexts.descriptive_flex_context_code%type;
10375:
10376: -- added by dbansal
10377: l_gre_name HR_ALL_ORGANIZATION_UNITS_TL.name%type;
10378: temp varchar2(20);
10379: --
10380: -- Date variables
10381: --