APPS.PQP_US_PENSION_EXTRACTS dependencies on HR_ORGANIZATION_UNITS

Line 4792: FROM hr_organization_units hou

4788:
4789: CURSOR csr_gre_name(c_gre_id IN NUMBER
4790: )IS
4791: SELECT hou.NAME
4792: FROM hr_organization_units hou
4793: WHERE hou.organization_id = c_gre_id;
4794:
4795: CURSOR csr_pay_name(c_payroll_id IN NUMBER
4796: ,c_end_date IN DATE

Line 4813: l_gre_name hr_organization_units.NAME%TYPE ;

4809: l_proc_name VARCHAR2(150) := g_proc_name ||'Set_ConcProg_Parameter_Values';
4810: l_extract_name ben_ext_dfn.NAME%TYPE;
4811: l_element_set PAY_ELEMENT_SETS.ELEMENT_SET_NAME%TYPE;
4812: l_element_name pay_element_types_f.element_name%TYPE;
4813: l_gre_name hr_organization_units.NAME%TYPE ;
4814: l_payroll_name PAY_PAYROLLS_F.PAYROLL_NAME%TYPE ;
4815: l_con_set_name PAY_CONSOLIDATION_SETS.CONSOLIDATION_SET_NAME%TYPE;
4816:
4817: BEGIN