DBA Data[Home] [Help]

APPS.IGS_PE_MATCH_SETS_PKG dependencies on IGS_LOOKUPS_VIEW

Line 259: SELECT LOOKUP_CODE FROM IGS_LOOKUPS_VIEW WHERE LOOKUP_TYPE = 'DUPLICATE_DATA_ELEMENTS' AND ENABLED_FLAG = 'Y';

255: CURSOR Src_Type IS
256: SELECT 'X' FROM IGS_PE_SRC_TYPES WHERE SOURCE_TYPE_ID = new_references.source_type_id AND SYSTEM_SOURCE_TYPE = 'MANUAL';
257:
258: CURSOR Dup_Data IS
259: SELECT LOOKUP_CODE FROM IGS_LOOKUPS_VIEW WHERE LOOKUP_TYPE = 'DUPLICATE_DATA_ELEMENTS' AND ENABLED_FLAG = 'Y';
260:
261: lv_SrcType VARCHAR2(1);
262: lv_RowId VARCHAR2(25);
263: lv_Partial_Inc VARCHAR2(1);