APPS.PQP_PENSION_TYPES_API dependencies on HR_ORGANIZATION_INFORMATION

Line 2648: FROM hr_organization_information

2644: organization_id,
2645: org_information1,
2646: nvl(org_information2,'31/12/4712') org_information2,
2647: org_information3
2648: FROM hr_organization_information
2649: WHERE org_information_context = 'PQP_NL_ABP_PT'
2650: AND org_information3 = to_char(p_pension_type_id)
2651: AND trunc(to_date(nvl(org_information2,'31/12/4712'),'DD/MM/RRRR')) > p_effective_end_date;
2652: