APPS.IGF_SL_DL_LI_IMP_PKG dependencies on IGS_OR_ORG_ALT_IDS
Line 342: IGS_OR_ORG_ALT_IDS OLI,
338: */
339: CURSOR c_get_dl_school IS
340: SELECT 'X'
341: FROM HZ_PARTIES HZ, 342: IGS_OR_ORG_ALT_IDS OLI, 343: IGS_OR_ORG_ALT_IDTYP OLT
344: WHERE OLI.ORG_STRUCTURE_ID = HZ.PARTY_NUMBER
345: AND OLI.ORG_ALTERNATE_ID_TYPE = OLT.ORG_ALTERNATE_ID_TYPE
346: AND SYSDATE BETWEEN OLI.START_DATE AND NVL (END_DATE, SYSDATE)