DBA Data[Home] [Help]

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)