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_ELC_BUS dependencies on HR_ALL_ORGANIZATION_UNITS

Line 22: -- HR_ALL_ORGANIZATION_UNITS.

18: -- ---------------------------------------------------------------------------
19: --
20: -- Description:
21: -- - Validates that a representative body id exists in table
22: -- HR_ALL_ORGANIZATION_UNITS.
23: -- - Validates that the rep_body_id compares with that in
24: -- table HR_ORGANIZATION_INFORMATION
25: --
26: -- Pre-conditions:

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

31: -- p_rep_body_id
32: --
33: --
34: -- Post Success:
35: -- If a row does exist in HR_ALL_ORGANIZATION_UNITS for the given
36: -- representative id then processing continues.
37: --
38: -- Post Failure:
39: -- If a row does not exist in HR_ALL_ORGANIZATION_UNITS for the given

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

35: -- If a row does exist in HR_ALL_ORGANIZATION_UNITS for the given
36: -- representative id then processing continues.
37: --
38: -- Post Failure:
39: -- If a row does not exist in HR_ALL_ORGANIZATION_UNITS for the given
40: -- representative id then an application error will be raised and
41: -- processing is terminated.
42: --
43: -- Access Status:

Line 63: from hr_all_organization_units hou

59: --
60: --
61: cursor csr_valid_rep_body is
62: select hou.organization_id
63: from hr_all_organization_units hou
64: where hou.organization_id = p_rep_body_id
65: and exists(select 1
66: from hr_organization_information hoi
67: where hoi.organization_id = hou.organization_id