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.IGS_OR_GEN_001 dependencies on IGS_OR_UNIT_REL

Line 178: FROM IGS_OR_UNIT_REL our

174: cp_org_unit_cd IGS_OR_UNIT.org_unit_cd%TYPE,
175: cp_start_dt IGS_OR_UNIT.start_dt%TYPE) IS
176: SELECT our.parent_org_unit_cd,
177: our.parent_start_dt
178: FROM IGS_OR_UNIT_REL our
179: WHERE our.child_org_unit_cd = cp_org_unit_cd and
180: our.child_start_dt = cp_start_dt and
181: our.logical_delete_dt IS NULL ; -- new validation as part of bug 2408794
182: BEGIN

Line 330: cp_org_unit_cd IGS_OR_UNIT_REL.parent_org_unit_cd%TYPE,

326: AND IGS_OR_STATUS.s_org_status = 'ACTIVE'
327: ORDER BY IGS_OR_UNIT.institution_cd;
328:
329: CURSOR c_ou_parent (
330: cp_org_unit_cd IGS_OR_UNIT_REL.parent_org_unit_cd%TYPE,
331: cp_start_dt IGS_OR_UNIT_REL.parent_start_dt%TYPE) IS
332: SELECT parent_org_unit_cd,
333: parent_start_dt
334: FROM IGS_OR_UNIT_REL,

Line 331: cp_start_dt IGS_OR_UNIT_REL.parent_start_dt%TYPE) IS

327: ORDER BY IGS_OR_UNIT.institution_cd;
328:
329: CURSOR c_ou_parent (
330: cp_org_unit_cd IGS_OR_UNIT_REL.parent_org_unit_cd%TYPE,
331: cp_start_dt IGS_OR_UNIT_REL.parent_start_dt%TYPE) IS
332: SELECT parent_org_unit_cd,
333: parent_start_dt
334: FROM IGS_OR_UNIT_REL,
335: IGS_OR_UNIT,

Line 334: FROM IGS_OR_UNIT_REL,

330: cp_org_unit_cd IGS_OR_UNIT_REL.parent_org_unit_cd%TYPE,
331: cp_start_dt IGS_OR_UNIT_REL.parent_start_dt%TYPE) IS
332: SELECT parent_org_unit_cd,
333: parent_start_dt
334: FROM IGS_OR_UNIT_REL,
335: IGS_OR_UNIT,
336: IGS_OR_STATUS
337: WHERE child_org_unit_cd = cp_org_unit_cd
338: AND child_start_dt = cp_start_dt

Line 363: SELECT IGS_OR_UNIT_REL.child_org_unit_cd,

359:
360: -- Cursor to find all the Child Org Unit Code of the Org Units related to the Org Unit.
361: CURSOR c_our_child
362: IS
363: SELECT IGS_OR_UNIT_REL.child_org_unit_cd,
364: IGS_OR_UNIT_REL.child_start_dt,
365: IGS_OR_UNIT.institution_cd
366: FROM IGS_OR_UNIT_REL,
367: IGS_OR_UNIT,

Line 364: IGS_OR_UNIT_REL.child_start_dt,

360: -- Cursor to find all the Child Org Unit Code of the Org Units related to the Org Unit.
361: CURSOR c_our_child
362: IS
363: SELECT IGS_OR_UNIT_REL.child_org_unit_cd,
364: IGS_OR_UNIT_REL.child_start_dt,
365: IGS_OR_UNIT.institution_cd
366: FROM IGS_OR_UNIT_REL,
367: IGS_OR_UNIT,
368: IGS_OR_STATUS

Line 366: FROM IGS_OR_UNIT_REL,

362: IS
363: SELECT IGS_OR_UNIT_REL.child_org_unit_cd,
364: IGS_OR_UNIT_REL.child_start_dt,
365: IGS_OR_UNIT.institution_cd
366: FROM IGS_OR_UNIT_REL,
367: IGS_OR_UNIT,
368: IGS_OR_STATUS
369: WHERE IGS_OR_UNIT_REL.parent_org_unit_cd = p_org_unit_cd
370: AND IGS_OR_UNIT_REL.parent_start_dt = p_start_dt

Line 369: WHERE IGS_OR_UNIT_REL.parent_org_unit_cd = p_org_unit_cd

365: IGS_OR_UNIT.institution_cd
366: FROM IGS_OR_UNIT_REL,
367: IGS_OR_UNIT,
368: IGS_OR_STATUS
369: WHERE IGS_OR_UNIT_REL.parent_org_unit_cd = p_org_unit_cd
370: AND IGS_OR_UNIT_REL.parent_start_dt = p_start_dt
371: AND IGS_OR_UNIT_REL.logical_delete_dt IS NULL
372: AND IGS_OR_UNIT.org_unit_cd = IGS_OR_UNIT_REL.child_org_unit_cd
373: AND IGS_OR_UNIT.start_dt = IGS_OR_UNIT_REL.child_start_dt

Line 370: AND IGS_OR_UNIT_REL.parent_start_dt = p_start_dt

366: FROM IGS_OR_UNIT_REL,
367: IGS_OR_UNIT,
368: IGS_OR_STATUS
369: WHERE IGS_OR_UNIT_REL.parent_org_unit_cd = p_org_unit_cd
370: AND IGS_OR_UNIT_REL.parent_start_dt = p_start_dt
371: AND IGS_OR_UNIT_REL.logical_delete_dt IS NULL
372: AND IGS_OR_UNIT.org_unit_cd = IGS_OR_UNIT_REL.child_org_unit_cd
373: AND IGS_OR_UNIT.start_dt = IGS_OR_UNIT_REL.child_start_dt
374: AND IGS_OR_STATUS.org_status = IGS_OR_UNIT.org_status

Line 371: AND IGS_OR_UNIT_REL.logical_delete_dt IS NULL

367: IGS_OR_UNIT,
368: IGS_OR_STATUS
369: WHERE IGS_OR_UNIT_REL.parent_org_unit_cd = p_org_unit_cd
370: AND IGS_OR_UNIT_REL.parent_start_dt = p_start_dt
371: AND IGS_OR_UNIT_REL.logical_delete_dt IS NULL
372: AND IGS_OR_UNIT.org_unit_cd = IGS_OR_UNIT_REL.child_org_unit_cd
373: AND IGS_OR_UNIT.start_dt = IGS_OR_UNIT_REL.child_start_dt
374: AND IGS_OR_STATUS.org_status = IGS_OR_UNIT.org_status
375: AND IGS_OR_STATUS.s_org_status = 'ACTIVE';

Line 372: AND IGS_OR_UNIT.org_unit_cd = IGS_OR_UNIT_REL.child_org_unit_cd

368: IGS_OR_STATUS
369: WHERE IGS_OR_UNIT_REL.parent_org_unit_cd = p_org_unit_cd
370: AND IGS_OR_UNIT_REL.parent_start_dt = p_start_dt
371: AND IGS_OR_UNIT_REL.logical_delete_dt IS NULL
372: AND IGS_OR_UNIT.org_unit_cd = IGS_OR_UNIT_REL.child_org_unit_cd
373: AND IGS_OR_UNIT.start_dt = IGS_OR_UNIT_REL.child_start_dt
374: AND IGS_OR_STATUS.org_status = IGS_OR_UNIT.org_status
375: AND IGS_OR_STATUS.s_org_status = 'ACTIVE';
376:

Line 373: AND IGS_OR_UNIT.start_dt = IGS_OR_UNIT_REL.child_start_dt

369: WHERE IGS_OR_UNIT_REL.parent_org_unit_cd = p_org_unit_cd
370: AND IGS_OR_UNIT_REL.parent_start_dt = p_start_dt
371: AND IGS_OR_UNIT_REL.logical_delete_dt IS NULL
372: AND IGS_OR_UNIT.org_unit_cd = IGS_OR_UNIT_REL.child_org_unit_cd
373: AND IGS_OR_UNIT.start_dt = IGS_OR_UNIT_REL.child_start_dt
374: AND IGS_OR_STATUS.org_status = IGS_OR_UNIT.org_status
375: AND IGS_OR_STATUS.s_org_status = 'ACTIVE';
376:
377: -- Fetch other active parents.

Line 379: cp_parent_org_unit_cd IGS_OR_UNIT_REL.parent_org_unit_cd%TYPE,

375: AND IGS_OR_STATUS.s_org_status = 'ACTIVE';
376:
377: -- Fetch other active parents.
378: CURSOR c_our_ou_os_parent (
379: cp_parent_org_unit_cd IGS_OR_UNIT_REL.parent_org_unit_cd%TYPE,
380: cp_parent_start_dt IGS_OR_UNIT_REL.parent_start_dt%TYPE,
381: cp_child_org_unit_cd IGS_OR_UNIT_REL.child_org_unit_cd%TYPE,
382: cp_child_start_dt IGS_OR_UNIT_REL.child_start_dt%TYPE) IS
383: SELECT parent_org_unit_cd,

Line 380: cp_parent_start_dt IGS_OR_UNIT_REL.parent_start_dt%TYPE,

376:
377: -- Fetch other active parents.
378: CURSOR c_our_ou_os_parent (
379: cp_parent_org_unit_cd IGS_OR_UNIT_REL.parent_org_unit_cd%TYPE,
380: cp_parent_start_dt IGS_OR_UNIT_REL.parent_start_dt%TYPE,
381: cp_child_org_unit_cd IGS_OR_UNIT_REL.child_org_unit_cd%TYPE,
382: cp_child_start_dt IGS_OR_UNIT_REL.child_start_dt%TYPE) IS
383: SELECT parent_org_unit_cd,
384: parent_start_dt

Line 381: cp_child_org_unit_cd IGS_OR_UNIT_REL.child_org_unit_cd%TYPE,

377: -- Fetch other active parents.
378: CURSOR c_our_ou_os_parent (
379: cp_parent_org_unit_cd IGS_OR_UNIT_REL.parent_org_unit_cd%TYPE,
380: cp_parent_start_dt IGS_OR_UNIT_REL.parent_start_dt%TYPE,
381: cp_child_org_unit_cd IGS_OR_UNIT_REL.child_org_unit_cd%TYPE,
382: cp_child_start_dt IGS_OR_UNIT_REL.child_start_dt%TYPE) IS
383: SELECT parent_org_unit_cd,
384: parent_start_dt
385: FROM IGS_OR_UNIT_REL,

Line 382: cp_child_start_dt IGS_OR_UNIT_REL.child_start_dt%TYPE) IS

378: CURSOR c_our_ou_os_parent (
379: cp_parent_org_unit_cd IGS_OR_UNIT_REL.parent_org_unit_cd%TYPE,
380: cp_parent_start_dt IGS_OR_UNIT_REL.parent_start_dt%TYPE,
381: cp_child_org_unit_cd IGS_OR_UNIT_REL.child_org_unit_cd%TYPE,
382: cp_child_start_dt IGS_OR_UNIT_REL.child_start_dt%TYPE) IS
383: SELECT parent_org_unit_cd,
384: parent_start_dt
385: FROM IGS_OR_UNIT_REL,
386: IGS_OR_UNIT,

Line 385: FROM IGS_OR_UNIT_REL,

381: cp_child_org_unit_cd IGS_OR_UNIT_REL.child_org_unit_cd%TYPE,
382: cp_child_start_dt IGS_OR_UNIT_REL.child_start_dt%TYPE) IS
383: SELECT parent_org_unit_cd,
384: parent_start_dt
385: FROM IGS_OR_UNIT_REL,
386: IGS_OR_UNIT,
387: IGS_OR_STATUS
388: WHERE child_org_unit_cd = cp_child_org_unit_cd
389: AND child_start_dt = cp_child_start_dt

Line 599: FROM IGS_OR_UNIT_REL,

595: -- Fetch active children.
596: CURSOR c_our_ou_os_child IS
597: SELECT child_org_unit_cd,
598: child_start_dt
599: FROM IGS_OR_UNIT_REL,
600: IGS_OR_UNIT,
601: IGS_OR_STATUS
602: WHERE parent_org_unit_cd = p_org_unit_cd
603: AND parent_start_dt = p_start_dt

Line 612: cp_parent_org_unit_cd IGS_OR_UNIT_REL.parent_org_unit_cd%TYPE,

608: AND IGS_OR_STATUS.s_org_status = 'ACTIVE';
609:
610: -- Fetch other active parents.
611: CURSOR c_our_ou_os_parent (
612: cp_parent_org_unit_cd IGS_OR_UNIT_REL.parent_org_unit_cd%TYPE,
613: cp_parent_start_dt IGS_OR_UNIT_REL.parent_start_dt%TYPE,
614: cp_child_org_unit_cd IGS_OR_UNIT_REL.child_org_unit_cd%TYPE,
615: cp_child_start_dt IGS_OR_UNIT_REL.child_start_dt%TYPE) IS
616: SELECT parent_org_unit_cd,

Line 613: cp_parent_start_dt IGS_OR_UNIT_REL.parent_start_dt%TYPE,

609:
610: -- Fetch other active parents.
611: CURSOR c_our_ou_os_parent (
612: cp_parent_org_unit_cd IGS_OR_UNIT_REL.parent_org_unit_cd%TYPE,
613: cp_parent_start_dt IGS_OR_UNIT_REL.parent_start_dt%TYPE,
614: cp_child_org_unit_cd IGS_OR_UNIT_REL.child_org_unit_cd%TYPE,
615: cp_child_start_dt IGS_OR_UNIT_REL.child_start_dt%TYPE) IS
616: SELECT parent_org_unit_cd,
617: parent_start_dt

Line 614: cp_child_org_unit_cd IGS_OR_UNIT_REL.child_org_unit_cd%TYPE,

610: -- Fetch other active parents.
611: CURSOR c_our_ou_os_parent (
612: cp_parent_org_unit_cd IGS_OR_UNIT_REL.parent_org_unit_cd%TYPE,
613: cp_parent_start_dt IGS_OR_UNIT_REL.parent_start_dt%TYPE,
614: cp_child_org_unit_cd IGS_OR_UNIT_REL.child_org_unit_cd%TYPE,
615: cp_child_start_dt IGS_OR_UNIT_REL.child_start_dt%TYPE) IS
616: SELECT parent_org_unit_cd,
617: parent_start_dt
618: FROM IGS_OR_UNIT_REL,

Line 615: cp_child_start_dt IGS_OR_UNIT_REL.child_start_dt%TYPE) IS

611: CURSOR c_our_ou_os_parent (
612: cp_parent_org_unit_cd IGS_OR_UNIT_REL.parent_org_unit_cd%TYPE,
613: cp_parent_start_dt IGS_OR_UNIT_REL.parent_start_dt%TYPE,
614: cp_child_org_unit_cd IGS_OR_UNIT_REL.child_org_unit_cd%TYPE,
615: cp_child_start_dt IGS_OR_UNIT_REL.child_start_dt%TYPE) IS
616: SELECT parent_org_unit_cd,
617: parent_start_dt
618: FROM IGS_OR_UNIT_REL,
619: IGS_OR_UNIT,

Line 618: FROM IGS_OR_UNIT_REL,

614: cp_child_org_unit_cd IGS_OR_UNIT_REL.child_org_unit_cd%TYPE,
615: cp_child_start_dt IGS_OR_UNIT_REL.child_start_dt%TYPE) IS
616: SELECT parent_org_unit_cd,
617: parent_start_dt
618: FROM IGS_OR_UNIT_REL,
619: IGS_OR_UNIT,
620: IGS_OR_STATUS
621: WHERE child_org_unit_cd = cp_child_org_unit_cd
622: AND child_start_dt = cp_child_start_dt