APPS.PQP_NL_PENSION_EXTRACTS dependencies on HR_ALL_ORGANIZATION_UNITS

Line 309: FROM hr_all_organization_units

305: -- Cursor to get the Organization name
306: -- ============================================================================
307: CURSOR csr_org_name (c_org_id IN Number)IS
308: SELECT NAME
309: FROM hr_all_organization_units
310: WHERE organization_id = c_org_id;
311:
312: -- =============================================================================
313: -- Cursor to chk for other primary assig. within the extract date range.

Line 2274: l_org_name hr_all_organization_units.NAME%TYPE;

2270: l_proc_name Varchar2(150) := g_proc_name ||'Set_ConcProg_Parameter_Values';
2271: l_extract_name ben_ext_dfn.NAME%TYPE;
2272: l_payroll_name PAY_PAYROLLS_F.PAYROLL_NAME%TYPE ;
2273: l_con_set_name PAY_CONSOLIDATION_SETS.CONSOLIDATION_SET_NAME%TYPE;
2274: l_org_name hr_all_organization_units.NAME%TYPE;
2275:
2276:
2277: BEGIN
2278: IF g_debug THEN

Line 2729: PROCEDURE Set_Er_Children ( p_org_id IN hr_all_organization_units.organization_id%TYPE

2725: -- =============================================================================
2726: --This Procedure stores the child orgs and sub orgs which are employer themselves of
2727: --the organization passed as parameter(employers) in table employer_child_list
2728: -- =============================================================================
2729: PROCEDURE Set_Er_Children ( p_org_id IN hr_all_organization_units.organization_id%TYPE
2730: ,p_business_group_id IN per_all_assignments_f.business_group_id%TYPE
2731: ,p_effective_date IN Date
2732: )
2733: IS

Line 2748: CURSOR csr_get_children(c_org_id hr_all_organization_units.organization_id%TYPE,

2744: AND Nvl(date_to,Hr_Api.g_eot)
2745: AND hoi.org_information_context = 'NL_BG_INFO';
2746:
2747: --Cursor to fetch immediate children of org
2748: CURSOR csr_get_children(c_org_id hr_all_organization_units.organization_id%TYPE,
2749: c_org_struct_ver_id per_org_structure_versions_v.org_structure_version_id%TYPE
2750: ) IS
2751: SELECT os.organization_id_child
2752: FROM (SELECT *

Line 2767: CURSOR csr_any_child_exists(c_org_id hr_all_organization_units.organization_id%TYPE,

2763: AND org_information_context = 'NL_ORG_INFORMATION'
2764: AND org_information3 IS NOT NULL
2765: AND org_information4 IS NOT NULL;
2766:
2767: CURSOR csr_any_child_exists(c_org_id hr_all_organization_units.organization_id%TYPE,
2768: c_org_struct_ver_id per_org_structure_versions_v.org_structure_version_id%TYPE
2769: ) IS
2770: SELECT 'x'
2771: FROM (SELECT *

Line 9644: l_org_id hr_all_organization_units.organization_id%TYPE;

9640: ,p_date_earned IN Date
9641: ,p_end_date OUT NOCOPY Date
9642: ) RETURN Number IS
9643:
9644: l_org_id hr_all_organization_units.organization_id%TYPE;
9645: l_ret_value Number := 0; --return
9646: l_org_info_id hr_organization_information.org_information_id%TYPE;
9647: l_named_hierarchy Number;
9648: l_version_id per_org_structure_versions_v.org_structure_version_id%TYPE DEFAULT NULL;

Line 9694: CURSOR c_get_valid_org_info(c_org_id IN hr_all_organization_units.organization_id%TYPE) IS

9690: AND business_group_id = p_business_group_id;
9691:
9692: --Cursor to find if there is any information record at the org level
9693: --if so return the org info id
9694: CURSOR c_get_valid_org_info(c_org_id IN hr_all_organization_units.organization_id%TYPE) IS
9695: SELECT hoi.org_information_id
9696: FROM hr_organization_information hoi
9697: WHERE hoi.org_information_context = 'PQP_NL_ABP_PT'
9698: AND hoi.org_information3 = To_Char(p_pension_type_id)

Line 16785: l_org_pram_id hr_all_organization_units.organization_id%TYPE;

16781: l_return_value Number := 0; --0= Sucess, -1=Error ;
16782: l_tmp_person_id Number;
16783: l_tmp_org_id Number;
16784: l_first_flag Number :=0;
16785: l_org_pram_id hr_all_organization_units.organization_id%TYPE;
16786: l_temp_org_pram_id hr_all_organization_units.organization_id%TYPE;
16787: l_org_detl g_org_list%TYPE;
16788: l_org_index Number :=1;
16789: l_global_contribution Number :=0;

Line 16786: l_temp_org_pram_id hr_all_organization_units.organization_id%TYPE;

16782: l_tmp_person_id Number;
16783: l_tmp_org_id Number;
16784: l_first_flag Number :=0;
16785: l_org_pram_id hr_all_organization_units.organization_id%TYPE;
16786: l_temp_org_pram_id hr_all_organization_units.organization_id%TYPE;
16787: l_org_detl g_org_list%TYPE;
16788: l_org_index Number :=1;
16789: l_global_contribution Number :=0;
16790: l_first_person_id Number;

Line 16802: l_org_name hr_all_organization_units.NAME%TYPE;

16798: l_sort_val Varchar2(15);
16799: l_org_count Number :=0;
16800: l_header_er_num Varchar2(4);
16801: l_trailer_er_num Varchar2(7);
16802: l_org_name hr_all_organization_units.NAME%TYPE;
16803: l_CodeA_R96_Contri Number :=0;
16804: l_CodeD_R96_Contri Number :=0;
16805: l_record96_count Number :=0;
16806: l_record96_rcd_id Number;