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 141: AND exists (select 'e' from hr_organization_information class, hr_org_info_types_by_class ctype

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