APPS.PQP_PTY_BUS dependencies on HR_ORGANIZATION_INFORMATION

Line 474: from hr_organization_information

470: --
471: Cursor csr_org_info_nl
472: (c_pension_type_id in pqp_pension_types_f.pension_type_id%TYPE) Is
473: select 'x'
474: from hr_organization_information
475: where org_information_context = 'PQP_NL_PENSION_TYPES'
476: and org_information1 = to_char(c_pension_type_id);
477:
478: -- added for UK

Line 482: from hr_organization_information

478: -- added for UK
479: Cursor csr_org_info_gb
480: (c_pension_type_id in pqp_pension_types_f.pension_type_id%TYPE) Is
481: select 'x'
482: from hr_organization_information
483: where org_information_context = 'PQP_GB_PENSION_TYPES_INFO'
484: and org_information1 = to_char(c_pension_type_id);
485:
486: -- added for HU

Line 490: from hr_organization_information

486: -- added for HU
487: Cursor csr_org_info_hu
488: (c_pension_type_id in pqp_pension_types_f.pension_type_id%TYPE) Is
489: select 'x'
490: from hr_organization_information
491: where org_information_context = 'HU_PENSION_TYPES_INFO'
492: and org_information1 = to_char(c_pension_type_id);
493:
494: l_proc varchar2(72) := g_package||'chk_provider_assignment';

Line 2706: FROM hr_organization_information

2702:
2703: --cursor to check if an org info row exists for the PT
2704: CURSOR c_chk_org_info(c_pension_type_id IN pqp_pension_types_f.pension_type_id%TYPE) IS
2705: SELECT 1
2706: FROM hr_organization_information
2707: WHERE org_information_context = 'PQP_NL_ABP_PT'
2708: AND org_information3 = to_char(c_pension_type_id);
2709:
2710: --cursor to check if an org info row exists for the PT

Line 2713: FROM hr_organization_information

2709:
2710: --cursor to check if an org info row exists for the PT
2711: CURSOR c_chk_pggm_org_info(c_pension_type_id IN pqp_pension_types_f.pension_type_id%TYPE) IS
2712: SELECT 1
2713: FROM hr_organization_information
2714: WHERE org_information_context = 'PQP_NL_PGGM_PT'
2715: AND org_information3 = to_char(c_pension_type_id);
2716:
2717: --cursor to check if an asg eit row exists for the PT

Line 2728: FROM hr_organization_information

2724:
2725: --cursor to get the end date for the org eit row for this PT
2726: CURSOR c_org_info_end_dt(c_pension_type_id IN pqp_pension_types_f.pension_type_id%TYPE) IS
2727: SELECT fnd_date.canonical_to_date(nvl(org_information2,'4712/12/31')) org_info_end_dt
2728: FROM hr_organization_information
2729: WHERE org_information3 = to_char(c_pension_type_id)
2730: AND org_information_context = 'PQP_NL_ABP_PT';
2731:
2732: --cursor to get the end date for the org eit row for this PT

Line 2735: FROM hr_organization_information

2731:
2732: --cursor to get the end date for the org eit row for this PT
2733: CURSOR c_pggm_org_info_end_dt(c_pension_type_id IN pqp_pension_types_f.pension_type_id%TYPE) IS
2734: SELECT fnd_date.canonical_to_date(nvl(org_information2,'4712/12/31')) org_info_end_dt
2735: FROM hr_organization_information
2736: WHERE org_information3 = to_char(c_pension_type_id)
2737: AND org_information_context = 'PQP_NL_PGGM_PT';
2738:
2739: --cursor to get the end date for the asg eit row for this PT