APPS.PQP_NL_PGGM_PENSION_EXTRACTS dependencies on HR_ALL_ORGANIZATION_UNITS

Line 171: FROM hr_all_organization_units

167: -- ============================================================================
168: CURSOR csr_org_name (c_org_id IN Number
169: )IS
170: SELECT NAME
171: FROM hr_all_organization_units
172: WHERE organization_id = c_org_id;
173: -- =============================================================================
174: -- Cursor to chk for other primary assig. within the extract date range.
175: -- =============================================================================

Line 337: l_org_name hr_all_organization_units.NAME%TYPE;

333: l_proc_name Varchar2(150) := g_proc_name ||'Set_ConcProg_Parameter_Values';
334: l_extract_name ben_ext_dfn.NAME%TYPE;
335: l_payroll_name PAY_PAYROLLS_F.PAYROLL_NAME%TYPE ;
336: l_con_set_name PAY_CONSOLIDATION_SETS.CONSOLIDATION_SET_NAME%TYPE;
337: l_org_name hr_all_organization_units.NAME%TYPE;
338:
339: BEGIN
340: Hr_Utility.set_location('Entering: '||l_proc_name, 5);
341:

Line 7785: l_org_pram_id hr_all_organization_units.organization_id%TYPE;

7781: l_return_value Number := 0; --0= Sucess, -1=Error;
7782: l_tmp_person_id Number;
7783: l_tmp_org_id Number;
7784: l_first_flag Number :=0;
7785: l_org_pram_id hr_all_organization_units.organization_id%TYPE;
7786: l_temp_org_pram_id hr_all_organization_units.organization_id%TYPE;
7787: l_org_detl g_org_list%TYPE;
7788: l_org_index Number :=1;
7789: l_global_contribution Number :=0;

Line 7786: l_temp_org_pram_id hr_all_organization_units.organization_id%TYPE;

7782: l_tmp_person_id Number;
7783: l_tmp_org_id Number;
7784: l_first_flag Number :=0;
7785: l_org_pram_id hr_all_organization_units.organization_id%TYPE;
7786: l_temp_org_pram_id hr_all_organization_units.organization_id%TYPE;
7787: l_org_detl g_org_list%TYPE;
7788: l_org_index Number :=1;
7789: l_global_contribution Number :=0;
7790: l_first_person_id Number;

Line 7801: l_org_name hr_all_organization_units.NAME%TYPE;

7797: sort_val Number :=1;
7798: l_sort_val Varchar2(15);
7799: l_emp_ext_chk Number:=0;
7800: l_org_count Number :=0;
7801: l_org_name hr_all_organization_units.NAME%TYPE;
7802: l_insert_trailer Number := 1;
7803: l_first_trailer_flag Number :=0;
7804: l_Person_Exists Varchar2(2):='y';
7805: i Number := 0;