APPS.PQP_PERASGADD_RIW dependencies on HR_LOCATIONS

Line 154: ,location_code hr_locations_all.location_code%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:
158: g_wstr_names t_asg_wrk_strs;

Line 416: from hr_locations hrl

412: cursor csr_location(c_location_id in number
413: ,c_business_group_id in number
414: ) is
415: select htl.location_code
416: from hr_locations hrl
417: ,hr_locations_all_tl htl
418: where hrl.location_id = c_location_id
419: and htl.location_id = hrl.location_id
420: and htl.language = Userenv('LANG')

Line 417: ,hr_locations_all_tl htl

413: ,c_business_group_id in number
414: ) is
415: select htl.location_code
416: from hr_locations hrl
417: ,hr_locations_all_tl htl
418: where hrl.location_id = c_location_id
419: and htl.location_id = hrl.location_id
420: and htl.language = Userenv('LANG')
421: and (hrl.business_group_id is null or

Line 1913: l_location_code hr_locations_all.location_code%type;

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;
1917: l_grade_name per_grades.name%type;

Line 7876: l_location_code hr_locations_all.location_code%type;

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;
7880: l_grade_name per_grades.name%type;