APPS.PQP_PENSION_TYPES_API dependencies on HR_ORGANIZATION_INFORMATION

Line 2575: FROM hr_organization_information

2571: organization_id,
2572: org_information1,
2573: nvl(org_information2,'31/12/4712') org_information2,
2574: org_information3
2575: FROM hr_organization_information
2576: WHERE org_information_context = 'PQP_NL_ABP_PT'
2577: AND org_information3 = to_char(p_pension_type_id)
2578: AND trunc(to_date(nvl(org_information2,'31/12/4712'),'DD/MM/RRRR')) > p_effective_end_date;
2579: