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.OZF_FUNDS_PUB dependencies on HR_ALL_ORGANIZATION_UNITS

Line 150: FROM hr_all_organization_units

146: AND media_name = p_task_name;
147:
148: CURSOR c_bus_unit_exists (p_bus_id IN NUMBER, p_bus_name IN VARCHAR, p_org_id IN NUMBER) IS
149: SELECT 1
150: FROM hr_all_organization_units
151: WHERE business_group_id
152: IN (SELECT business_group_id
153: FROM hr_all_organization_units
154: WHERE organization_id = p_org_id

Line 153: FROM hr_all_organization_units

149: SELECT 1
150: FROM hr_all_organization_units
151: WHERE business_group_id
152: IN (SELECT business_group_id
153: FROM hr_all_organization_units
154: WHERE organization_id = p_org_id
155: AND NVL(date_from, SYSDATE) <= SYSDATE
156: AND NVL(date_to, SYSDATE) >= SYSDATE)
157: AND type = 'BU' AND NVL(date_from, SYSDATE) <= SYSDATE

Line 164: FROM hr_all_organization_units

160: AND organization_id = p_bus_id;
161:
162: CURSOR c_bus_id_exists (p_bus_id IN NUMBER, p_org_id IN NUMBER) IS
163: SELECT 1
164: FROM hr_all_organization_units
165: WHERE business_group_id
166: IN (SELECT business_group_id
167: FROM hr_all_organization_units
168: WHERE organization_id = p_org_id

Line 167: FROM hr_all_organization_units

163: SELECT 1
164: FROM hr_all_organization_units
165: WHERE business_group_id
166: IN (SELECT business_group_id
167: FROM hr_all_organization_units
168: WHERE organization_id = p_org_id
169: AND NVL(date_from, SYSDATE) <= SYSDATE
170: AND NVL(date_to, SYSDATE) >= SYSDATE)
171: AND type = 'BU' AND NVL(date_from, SYSDATE) <= SYSDATE

Line 177: FROM hr_all_organization_units

173: AND organization_id = p_bus_id;
174:
175: CURSOR c_bus_name_exists (p_bus_name IN VARCHAR2, p_org_id IN NUMBER) IS
176: SELECT organization_id
177: FROM hr_all_organization_units
178: WHERE business_group_id
179: IN (SELECT business_group_id
180: FROM hr_all_organization_units
181: WHERE organization_id = p_org_id

Line 180: FROM hr_all_organization_units

176: SELECT organization_id
177: FROM hr_all_organization_units
178: WHERE business_group_id
179: IN (SELECT business_group_id
180: FROM hr_all_organization_units
181: WHERE organization_id = p_org_id
182: AND NVL(date_from, SYSDATE) <= SYSDATE
183: AND NVL(date_to, SYSDATE) >= SYSDATE)
184: AND type = 'BU' AND NVL(date_from, SYSDATE) <= SYSDATE