DBA Data[Home] [Help]

APPS.IGF_SL_UPLOAD_XML dependencies on IGS_OR_ORG_ALT_IDS

Line 142: FROM IGS_OR_ORG_ALT_IDS REP,

138: -- Who When What
139: -----------------------------------------------------------------------------------
140: CURSOR chk_id (cp_entity_id VARCHAR2) IS
141: SELECT REP.ORG_ALTERNATE_ID ENTITY_ID
142: FROM IGS_OR_ORG_ALT_IDS REP,
143: IGS_OR_ORG_ALT_IDTYP_V REPID
144: WHERE REP.ORG_ALTERNATE_ID_TYPE = REPID.ORG_ALTERNATE_ID_TYPE
145: AND REPID.SYSTEM_ID_TYPE = 'ENTITY_ID'
146: AND SYSDATE BETWEEN REP.START_DATE AND NVL(REP.END_DATE, SYSDATE)