APPS.IGS_OR_VAL_OU dependencies on IGS_OR_STATUS

Line 209: FROM IGS_OR_STATUS

205:
206: SELECT closed_ind
207:
208:
209: FROM IGS_OR_STATUS
210:
211:
212: WHERE org_status = p_org_status
213:

Line 289: FROM IGS_OR_STATUS

285:
286: SELECT s_org_status
287:
288:
289: FROM IGS_OR_STATUS
290:
291:
292: WHERE org_status = p_org_status;
293:

Line 322: IGS_OR_STATUS

318:
319: IGS_OR_UNIT,
320:
321:
322: IGS_OR_STATUS
323:
324:
325: WHERE child_org_unit_cd = cp_org_unit_cd
326:

Line 340: AND IGS_OR_UNIT.org_status = IGS_OR_STATUS.org_status;

336:
337: AND start_dt = parent_start_dt
338:
339:
340: AND IGS_OR_UNIT.org_status = IGS_OR_STATUS.org_status;
341:
342:
343: -- Fetch active child records.
344:

Line 361: IGS_OR_STATUS

357:
358: IGS_OR_UNIT,
359:
360:
361: IGS_OR_STATUS
362:
363:
364: WHERE parent_org_unit_cd = p_org_unit_cd
365:

Line 379: AND IGS_OR_UNIT.org_status = IGS_OR_STATUS.org_status

375:
376: AND start_dt = child_start_dt
377:
378:
379: AND IGS_OR_UNIT.org_status = IGS_OR_STATUS.org_status
380:
381:
382: AND s_org_status = 'ACTIVE';
383:

Line 385: v_s_org_status IGS_OR_STATUS.s_org_status%TYPE;

381:
382: AND s_org_status = 'ACTIVE';
383:
384:
385: v_s_org_status IGS_OR_STATUS.s_org_status%TYPE;
386:
387:
388: v_active_parents BOOLEAN DEFAULT FALSE;
389:

Line 975: FROM IGS_OR_STATUS

971:
972: SELECT s_org_status
973:
974:
975: FROM IGS_OR_STATUS
976:
977:
978: WHERE org_status = p_org_status;
979: