APPS.PQP_PENSION_EXTRACTS dependencies on HR_ORGANIZATION_UNITS

Line 3662: FROM hr_organization_units hou

3658:
3659: CURSOR csr_gre_name(c_gre_id IN NUMBER
3660: )IS
3661: SELECT hou.NAME
3662: FROM hr_organization_units hou
3663: WHERE hou.organization_id = c_gre_id;
3664:
3665: CURSOR csr_pay_name(c_payroll_id IN NUMBER
3666: ,c_end_date IN DATE

Line 3702: l_gre_name hr_organization_units.NAME%TYPE ;

3698: l_proc_name VARCHAR2(150) := g_proc_name ||'Set_ConcProg_Parameter_Values';
3699: l_extract_name ben_ext_dfn.NAME%TYPE;
3700: l_element_set pay_element_sets.element_set_name%TYPE;
3701: l_element_name pay_element_types_f.element_name%TYPE;
3702: l_gre_name hr_organization_units.NAME%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;