APPS.IGF_AP_ISIR_MATCHED_PKG dependencies on IGS_OR_ORG_ALT_IDTYP

Line 1438: igs_or_org_alt_idtyp olt

1434: CURSOR c_get_object_id(p_school_code igf_ap_isir_matched_all.first_college%TYPE) IS
1435: SELECT hz.party_id party_id
1436: FROM hz_parties hz,
1437: igs_or_org_alt_ids oli,
1438: igs_or_org_alt_idtyp olt
1439: WHERE oli.org_structure_id = hz.party_number
1440: AND oli.org_alternate_id_type = olt.org_alternate_id_type
1441: AND SYSDATE BETWEEN oli.start_date AND NVL(oli.end_date, SYSDATE)
1442: AND hz.status = 'A'