DBA Data[Home] [Help]

APPS.HR_ORI_BUS dependencies on HR_ORG_INFORMATION_TYPES

Line 1590: FROM hr_org_information_types hoit

1586: INTO l_exists
1587: FROM sys.dual
1588: WHERE EXISTS
1589: (SELECT hoit.org_information_type
1590: FROM hr_org_information_types hoit
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

Line 1682: ,hr_org_information_types hoit

1678: FROM sys.dual
1679: WHERE EXISTS
1680: (SELECT null
1681: FROM hr_organization_information hoi
1682: ,hr_org_information_types hoit
1683: WHERE hoi.org_information_context = p_org_information_context
1684: AND hoi.organization_id = p_organization_id
1685: AND hoit.org_information_type = p_org_information_context
1686: AND hoit.navigation_method = 'GS');