APPS.IGS_HE_IMPORT_DATA dependencies on IGS_OR_ORG_ALT_IDTYP

Line 1129: FROM igs_or_org_alt_idtyp

1125:
1126: -- Check if alternate id type HESA_INST for institution is setup
1127: CURSOR c_alt_orgid IS
1128: SELECT 'X'
1129: FROM igs_or_org_alt_idtyp
1130: WHERE system_id_type = 'HESA_INST'
1131: AND NVL (close_ind, 'N') = 'N' ;
1132:
1133: l_altid VARCHAR2(1) ;

Line 1238: FROM IGS_OR_ORG_ALT_IDS OAI,IGS_OR_ORG_ALT_IDTYP_V OAIT

1234:
1235: -- get the oss inst code
1236: CURSOR c_inst( cp_inst_code igs_or_org_alt_ids.org_alternate_id%TYPE ) IS
1237: SELECT ORG_STRUCTURE_ID
1238: FROM IGS_OR_ORG_ALT_IDS OAI,IGS_OR_ORG_ALT_IDTYP_V OAIT
1239: WHERE OAI.ORG_alternate_ID = CP_INST_CODE
1240: AND OAI.ORG_STRUCTURE_TYPE = 'INSTITUTE'
1241: AND TRUNC (SYSDATE) BETWEEN TRUNC (OAI.START_DATE) AND NVL (TRUNC (OAI.END_DATE), TRUNC (SYSDATE)+1)
1242: AND OAI.ORG_ALTERNATE_ID_TYPE = OAIT.ORG_ALTERNATE_ID_TYPE