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_SUPERVISOR_SS dependencies on HR_ORG_INFO_TYPES_BY_CLASS

Line 146: AND exists (select 'e' from hr_organization_information class, hr_org_info_types_by_class ctype

142: AND v.name = 'P_ORGANIZATION_ID'
143: AND v.number_value = hao.organization_id
144: )
145: and rownum < 2)
146: AND exists (select 'e' from hr_organization_information class, hr_org_info_types_by_class ctype
147: where ctype.org_information_type = 'Organization Name Alias'
148: and ctype.org_classification = class.org_information1
149: and class.org_information_context = 'CLASS'
150: and class.org_information2 = 'Y'