APPS.PQP_HROSS_INTEGRATION dependencies on HR_LOCATIONS

Line 348: FROM hr_locations hrl

344: CURSOR csr_location(c_location_id IN Number
345: ,c_business_group_id IN Number
346: ) IS
347: SELECT htl.location_code
348: FROM hr_locations hrl
349: ,hr_locations_all_tl htl
350: WHERE hrl.location_id = c_location_id
351: AND htl.location_id = hrl.location_id
352: AND htl.LANGUAGE = Userenv('LANG')

Line 349: ,hr_locations_all_tl htl

345: ,c_business_group_id IN Number
346: ) IS
347: SELECT htl.location_code
348: FROM hr_locations hrl
349: ,hr_locations_all_tl htl
350: WHERE hrl.location_id = c_location_id
351: AND htl.location_id = hrl.location_id
352: AND htl.LANGUAGE = Userenv('LANG')
353: AND (hrl.business_group_id IS NULL OR

Line 2741: l_location_code hr_locations_all.location_code%TYPE;

2737: l_cur_add_rec per_addresses%ROWTYPE;
2738: l_cont_rec per_contact_relationships%ROWTYPE;
2739: l_pay_basis_name per_pay_bases.NAME%TYPE;
2740: l_organization_name hr_all_organization_units.NAME%TYPE;
2741: l_location_code hr_locations_all.location_code%TYPE;
2742: l_payroll_name pay_payrolls_f.payroll_name%TYPE;
2743: l_job_name per_jobs.NAME%TYPE;
2744: l_position_name per_positions.NAME%TYPE;
2745: l_grade_name per_grades.NAME%TYPE;

Line 3933: l_location_code hr_locations_all.location_code%TYPE;

3929: l_api_name hr_api_modules.module_name%TYPE;
3930: l_user_person_type per_person_types.user_person_type%TYPE;
3931: l_pay_basis_name per_pay_bases.NAME%TYPE;
3932: l_organization_name hr_all_organization_units.NAME%TYPE;
3933: l_location_code hr_locations_all.location_code%TYPE;
3934: l_payroll_name pay_payrolls_f.payroll_name%TYPE;
3935: l_job_name per_jobs.NAME%TYPE;
3936: l_position_name per_positions.NAME%TYPE;
3937: l_grade_name per_grades.NAME%TYPE;