APPS.PQP_PENSION_EXTRACTS dependencies on HR_LOCATIONS_ALL

Line 3695: FROM hr_locations_all

3691:
3692: CURSOR csr_location_code (c_location_id IN NUMBER
3693: )IS
3694: SELECT location_code
3695: FROM hr_locations_all
3696: WHERE location_id = c_location_id;
3697:
3698: l_proc_name VARCHAR2(150) := g_proc_name ||'Set_ConcProg_Parameter_Values';
3699: l_extract_name ben_ext_dfn.NAME%TYPE;

Line 3707: l_location hr_locations_all.location_code%TYPE;

3703: l_payroll_name pay_payrolls_f.payroll_name%TYPE ;
3704: l_con_set_name pay_consolidation_sets.consolidation_set_name%TYPE;
3705: l_org_name hr_all_organization_units.NAME%TYPE;
3706: l_person_type per_person_types.user_person_type%TYPE;
3707: l_location hr_locations_all.location_code%TYPE;
3708: BEGIN
3709: hr_utility.set_location('Entering: '||l_proc_name, 5);
3710: OPEN csr_ext_name( c_ext_dfn_id => p_ext_dfn_id);
3711: FETCH csr_ext_name INTO l_extract_name;