DBA Data[Home] [Help]

APPS.HR_ORI_BUS dependencies on HR_ORG_INFO_TYPES_BY_CLASS

Line 509: hr_org_info_types_by_class oitbc

505: where exists
506: (select null
507: from hr_organization_units org,
508: hr_organization_information org2,
509: hr_org_info_types_by_class oitbc
510: where org.organization_id = p_organization_id
511: and org.organization_id = org2.organization_id
512: and org2.org_information_context = 'CLASS'
513: and org2.org_information2 = 'Y'

Line 1595: FROM hr_org_info_types_by_class hitbc

1591: WHERE hoit.org_information_type = p_org_information_context
1592: AND (hoit.navigation_method = 'GS' OR hoit.navigation_method = 'GM' OR hoit.navigation_method = 'LOC')
1593: AND EXISTS
1594: (SELECT null
1595: FROM hr_org_info_types_by_class hitbc
1596: ,hr_organization_information hoi
1597: WHERE hitbc.org_information_type = hoit.org_information_type
1598: AND hitbc.org_classification = hoi.org_information1
1599: AND hoi.org_information2 = 'Y'