APPS.PQP_PTY_BUS dependencies on FND_DATE

Line 2727: SELECT fnd_date.canonical_to_date(nvl(org_information2,'4712/12/31')) org_info_end_dt

2723: AND aei_information3 = to_char(c_pension_type_id);
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:

Line 2734: SELECT fnd_date.canonical_to_date(nvl(org_information2,'4712/12/31')) org_info_end_dt

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
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:

Line 2741: SELECT fnd_date.canonical_to_date(nvl(aei_information2,'4712/12/31')) asg_info_end_dt

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
2740: CURSOR c_asg_info_end_dt(c_pension_type_id IN pqp_pension_types_f.pension_type_id%TYPE) IS
2741: SELECT fnd_date.canonical_to_date(nvl(aei_information2,'4712/12/31')) asg_info_end_dt
2742: FROM per_assignment_extra_info
2743: WHERE aei_information3 = to_char(c_pension_type_id)
2744: AND aei_information_category = 'NL_ABP_PI'
2745: AND information_type = 'NL_ABP_PI';