APPS.PQP_HROSS_INTEGRATION dependencies on HR_ALL_ORGANIZATION_UNITS

Line 362: FROM hr_all_organization_units_tl htl

358: ,c_business_group_id IN Number
359: ,c_effective_date IN Date
360: ) IS
361: SELECT htl.NAME
362: FROM hr_all_organization_units_tl htl
363: ,hr_all_organization_units hao
364: WHERE hao.organization_id = c_organization_id
365: AND hao.business_group_id = c_business_group_id
366: AND htl.organization_id = hao.organization_id

Line 363: ,hr_all_organization_units hao

359: ,c_effective_date IN Date
360: ) IS
361: SELECT htl.NAME
362: FROM hr_all_organization_units_tl htl
363: ,hr_all_organization_units hao
364: WHERE hao.organization_id = c_organization_id
365: AND hao.business_group_id = c_business_group_id
366: AND htl.organization_id = hao.organization_id
367: AND htl.LANGUAGE = Userenv('LANG')

Line 2740: l_organization_name hr_all_organization_units.NAME%TYPE;

2736: per_contact_relationships.object_version_number%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;

Line 3932: l_organization_name hr_all_organization_units.NAME%TYPE;

3928: l_if_end_dated Varchar2(20);
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;