APPS.IGS_GE_VAL_PARAM dependencies on IGS_OR_STATUS

Line 941: IGS_OR_STATUS ous

937: CURSOR c_cv(cp_org_cd IGS_OR_UNIT.org_unit_cd%TYPE)
938: IS
939: SELECT 'x'
940: FROM IGS_OR_UNIT ou,
941: IGS_OR_STATUS ous
942: WHERE org_unit_cd LIKE cp_org_cd
943: AND ous.org_status = ou.org_status
944: AND ous.s_org_status = 'ACTIVE';
945: --