APPS.IGS_EN_GEN_008 dependencies on IGS_OR_STATUS

Line 1211: IGS_OR_STATUS os

1207: crv.course_type like p_course_type AND
1208: (crv.responsible_org_unit_cd LIKE p_responsible_org_unit_cd OR
1209: EXISTS (SELECT 'x'
1210: FROM IGS_OR_INST_ORG_BASE_V ou,
1211: IGS_OR_STATUS os
1212: WHERE ou.PARTY_NUMBER LIKE p_responsible_org_unit_cd AND
1213: ou.org_status = os.org_status AND
1214: ou.inst_org_ind = 'O' AND
1215: os.s_org_status = cst_active AND

Line 1332: IGS_OR_STATUS os

1328: crv.course_type LIKE p_course_type AND
1329: (crv.responsible_org_unit_cd LIKE p_responsible_org_unit_cd OR
1330: EXISTS (SELECT 'x'
1331: FROM IGS_OR_UNIT ou,
1332: IGS_OR_STATUS os
1333: WHERE ou.org_unit_cd LIKE p_responsible_org_unit_cd AND
1334: ou.org_status = os.org_status AND
1335: os.s_org_status = cst_active AND
1336: IGS_OR_GEN_001.ORGP_GET_WITHIN_OU(