eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[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 1605: FROM hr_org_info_types_by_class hitbc

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
1605: FROM hr_org_info_types_by_class hitbc
1606: ,hr_organization_information hoi
1607: WHERE hitbc.org_information_type = hoit.org_information_type
1608: AND hitbc.org_classification = hoi.org_information1
1609: AND hoi.org_information2 = 'Y'