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_ALL_ORGANIZATION_UNITS

Line 259: -- HR_ALL_ORGANIZATION_UNITS.

255: -- ---------------------------------------------------------------------------
256: --
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:

Line 271: -- If a row does exist in HR_ALL_ORGANIZATION_UNITS for the given

267: -- p_constituency_id
268: --
269: --
270: -- Post Success:
271: -- If a row does exist in HR_ALL_ORGANIZATION_UNITS for the given
272: -- constituency id then processing continues.
273: --
274: -- Post Failure:
275: -- If a row does not exist in HR_ALL_ORGANIZATION_UNITS for the given

Line 275: -- If a row does not exist in HR_ALL_ORGANIZATION_UNITS for the given

271: -- If a row does exist in HR_ALL_ORGANIZATION_UNITS for the given
272: -- constituency id then processing continues.
273: --
274: -- Post Failure:
275: -- If a row does not exist in HR_ALL_ORGANIZATION_UNITS for the given
276: -- constituency id then an application error will be raised and
277: -- processing is terminated.
278: --
279: -- Access Status:

Line 298: from hr_all_organization_units haou

294: l_constituency_id number;
295: --
296: cursor csr_valid_const_id is
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'