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_VAL_INS dependencies on IGS_OR_UNIT

Line 299: FROM IGS_OR_UNIT,

295: CURSOR c_ou IS
296:
297: SELECT org_unit_cd
298:
299: FROM IGS_OR_UNIT,
300:
301: IGS_OR_STATUS
302:
303: WHERE institution_cd = p_institution_cd

Line 305: AND IGS_OR_UNIT.org_status = IGS_OR_STATUS.org_status

301: IGS_OR_STATUS
302:
303: WHERE institution_cd = p_institution_cd
304:
305: AND IGS_OR_UNIT.org_status = IGS_OR_STATUS.org_status
306:
307: AND IGS_OR_STATUS.s_org_status = 'ACTIVE';
308:
309: v_org_unit_cd IGS_OR_UNIT.org_unit_cd%TYPE;

Line 309: v_org_unit_cd IGS_OR_UNIT.org_unit_cd%TYPE;

305: AND IGS_OR_UNIT.org_status = IGS_OR_STATUS.org_status
306:
307: AND IGS_OR_STATUS.s_org_status = 'ACTIVE';
308:
309: v_org_unit_cd IGS_OR_UNIT.org_unit_cd%TYPE;
310:
311: v_other_detail VARCHAR2(255);
312:
313: BEGIN