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 2253: l_org_name hr_all_organization_units.NAME%TYPE;

2249: l_proc_name Varchar2(150) := g_proc_name ||'Set_ConcProg_Parameter_Values';
2250: l_extract_name ben_ext_dfn.NAME%TYPE;
2251: l_payroll_name PAY_PAYROLLS_F.PAYROLL_NAME%TYPE ;
2252: l_con_set_name PAY_CONSOLIDATION_SETS.CONSOLIDATION_SET_NAME%TYPE;
2253: l_org_name hr_all_organization_units.NAME%TYPE;
2254:
2255:
2256: BEGIN
2257: IF g_debug THEN

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

2704: -- =============================================================================
2705: --This Procedure stores the child orgs and sub orgs which are employer themselves of
2706: --the organization passed as parameter(employers) in table employer_child_list
2707: -- =============================================================================
2708: PROCEDURE Set_Er_Children ( p_org_id IN hr_all_organization_units.organization_id%TYPE
2709: ,p_business_group_id IN per_all_assignments_f.business_group_id%TYPE
2710: ,p_effective_date IN Date
2711: )
2712: IS

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

2723: AND Nvl(date_to,Hr_Api.g_eot)
2724: AND hoi.org_information_context = 'NL_BG_INFO';
2725:
2726: --Cursor to fetch immediate children of org
2727: CURSOR csr_get_children(c_org_id hr_all_organization_units.organization_id%TYPE,
2728: c_org_struct_ver_id per_org_structure_versions_v.org_structure_version_id%TYPE
2729: ) IS
2730: SELECT os.organization_id_child
2731: FROM (SELECT *

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

2742: AND org_information_context = 'NL_ORG_INFORMATION'
2743: AND org_information3 IS NOT NULL
2744: AND org_information4 IS NOT NULL;
2745:
2746: CURSOR csr_any_child_exists(c_org_id hr_all_organization_units.organization_id%TYPE,
2747: c_org_struct_ver_id per_org_structure_versions_v.org_structure_version_id%TYPE
2748: ) IS
2749: SELECT 'x'
2750: FROM (SELECT *

Line 9305: l_org_id hr_all_organization_units.organization_id%TYPE;

9301: ,p_date_earned IN Date
9302: ,p_end_date OUT NOCOPY Date
9303: ) RETURN Number IS
9304:
9305: l_org_id hr_all_organization_units.organization_id%TYPE;
9306: l_ret_value Number := 0; --return
9307: l_org_info_id hr_organization_information.org_information_id%TYPE;
9308: l_named_hierarchy Number;
9309: l_version_id per_org_structure_versions_v.org_structure_version_id%TYPE DEFAULT NULL;

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

9351: AND business_group_id = p_business_group_id;
9352:
9353: --Cursor to find if there is any information record at the org level
9354: --if so return the org info id
9355: CURSOR c_get_valid_org_info(c_org_id IN hr_all_organization_units.organization_id%TYPE) IS
9356: SELECT hoi.org_information_id
9357: FROM hr_organization_information hoi
9358: WHERE hoi.org_information_context = 'PQP_NL_ABP_PT'
9359: AND hoi.org_information3 = To_Char(p_pension_type_id)

Line 16395: l_org_pram_id hr_all_organization_units.organization_id%TYPE;

16391: l_return_value Number := 0; --0= Sucess, -1=Error ;
16392: l_tmp_person_id Number;
16393: l_tmp_org_id Number;
16394: l_first_flag Number :=0;
16395: l_org_pram_id hr_all_organization_units.organization_id%TYPE;
16396: l_temp_org_pram_id hr_all_organization_units.organization_id%TYPE;
16397: l_org_detl g_org_list%TYPE;
16398: l_org_index Number :=1;
16399: l_global_contribution Number :=0;

Line 16396: l_temp_org_pram_id hr_all_organization_units.organization_id%TYPE;

16392: l_tmp_person_id Number;
16393: l_tmp_org_id Number;
16394: l_first_flag Number :=0;
16395: l_org_pram_id hr_all_organization_units.organization_id%TYPE;
16396: l_temp_org_pram_id hr_all_organization_units.organization_id%TYPE;
16397: l_org_detl g_org_list%TYPE;
16398: l_org_index Number :=1;
16399: l_global_contribution Number :=0;
16400: l_first_person_id Number;

Line 16412: l_org_name hr_all_organization_units.NAME%TYPE;

16408: l_sort_val Varchar2(15);
16409: l_org_count Number :=0;
16410: l_header_er_num Varchar2(4);
16411: l_trailer_er_num Varchar2(7);
16412: l_org_name hr_all_organization_units.NAME%TYPE;
16413: l_CodeA_R96_Contri Number :=0;
16414: l_CodeD_R96_Contri Number :=0;
16415: l_record96_count Number :=0;
16416: l_record96_rcd_id Number;