APPS.PQH_ASG_WRAPPER dependencies on HR_ORGANIZATION_INFORMATION

Line 1588: from hr_organization_information hoi_estab

1584: p_VALIDATE IN BOOLEAN ) IS
1585: --
1586: cursor csr_check_estab is
1587: select count(organization_id)
1588: from hr_organization_information hoi_estab
1589: where hoi_estab.organization_id = p_organization_id
1590: and hoi_estab.org_information_context || '' = 'CLASS'
1591: and hoi_estab.org_information1 = 'FR_ETABLISSEMENT'
1592: and hoi_estab.org_information2= 'Y';