DBA Data[Home] [Help]

APPS.PER_CN_SHARED_INFO dependencies on HR_ORGANIZATION_INFORMATION

Line 162: FROM hr_organization_information info

158: AND POS.primary_structure_flag='Y'
159: AND POS.organization_structure_id = POSV.organization_structure_id
160: AND POSE.organization_id_child = p_organization_id
161: AND EXISTS (SELECT 1
162: FROM hr_organization_information info
163: WHERE info.org_information1 = 'HR_ORG'
164: AND info.org_information_context = 'CLASS'
165: AND info.organization_id = POSE.organization_id_parent
166: AND info.org_information2 = 'Y');