DBA Data[Home] [Help]

APPS.IGF_SL_DL_LI_IMP_PKG dependencies on IGS_OR_ORG_ALT_IDTYP

Line 343: IGS_OR_ORG_ALT_IDTYP OLT

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)
347: AND HZ.STATUS = 'A'