DBA Data[Home] [Help]

APPS.HR_ORI_BUS dependencies on HR_ORG_INFORMATION_TYPES

Line 1600: FROM hr_org_information_types hoit

1596: INTO l_exists
1597: FROM sys.dual
1598: WHERE EXISTS
1599: (SELECT hoit.org_information_type
1600: FROM hr_org_information_types hoit
1601: WHERE hoit.org_information_type = p_org_information_context
1602: AND (hoit.navigation_method = 'GS' OR hoit.navigation_method = 'GM' OR hoit.navigation_method = 'LOC')
1603: AND EXISTS
1604: (SELECT null

Line 1692: ,hr_org_information_types hoit

1688: FROM sys.dual
1689: WHERE EXISTS
1690: (SELECT null
1691: FROM hr_organization_information hoi
1692: ,hr_org_information_types hoit
1693: WHERE hoi.org_information_context = p_org_information_context
1694: AND hoi.organization_id = p_organization_id
1695: AND hoit.org_information_type = p_org_information_context
1696: AND hoit.navigation_method = 'GS');