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.

APPS.PER_ECO_BUS dependencies on HR_ORGANIZATION_INFORMATION

Line 261: -- table HR_ORGANIZATION_INFORMATION

257: -- Description:
258: -- - Validates that a constituency id exists in table
259: -- HR_ALL_ORGANIZATION_UNITS.
260: -- - Validates that the constituency compares with that in
261: -- table HR_ORGANIZATION_INFORMATION
262: --
263: -- Pre-conditions:
264: -- None.
265: --

Line 301: from hr_organization_information hoi

297: select haou.organization_id
298: from hr_all_organization_units haou
299: where haou.organization_id = p_constituency_id
300: and exists(select 1
301: from hr_organization_information hoi
302: where hoi.org_information_context='CLASS'
303: and hoi.org_information1='CONSTITUENCY'
304: and hoi.org_information2='Y');
305: --