APPS.PQP_PERASGADD_RIW dependencies on HR_LOCATIONS

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

Line 415: from hr_locations hrl

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

Line 416: ,hr_locations_all_tl htl

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

Line 1811: l_location_code hr_locations_all.location_code%type;

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

Line 7472: l_location_code hr_locations_all.location_code%type;

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