APPS.IEX_STRATEGY_TEMPLATES_PKG dependencies on IEX_STRATEGY_WORK_TEMP_XREF

Line 129: FROM IEX_STRATEGY_WORK_TEMP_XREF

125: LAST_UPDATED_BY,
126: LAST_UPDATE_LOGIN,
127: REQUEST_ID,
128: OBJECT_VERSION_NUMBER
129: FROM IEX_STRATEGY_WORK_TEMP_XREF
130: WHERE STRATEGY_TEMP_ID = vTemplate_ID;
131:
132: BEGIN
133:

Line 294: select IEX_STRATEGY_WORK_TEMP_XREF_S.NEXTVAL

290:
291: IEX_DEBUG_PUB.logmessage('Copy XRef for Template = ' || tempCur.STRATEGY_TEMP_ID ||
292: ' and Xref ID = ' || xrefCur.WORK_TEMP_XREF_ID );
293:
294: select IEX_STRATEGY_WORK_TEMP_XREF_S.NEXTVAL
295: into nNextXrefID FROM DUAL;
296:
297: IEX_DEBUG_PUB.logmessage('Next Work Item Xref ID from seq = ' || nNextXrefID);
298:

Line 299: INSERT INTO IEX_STRATEGY_WORK_TEMP_XREF(

295: into nNextXrefID FROM DUAL;
296:
297: IEX_DEBUG_PUB.logmessage('Next Work Item Xref ID from seq = ' || nNextXrefID);
298:
299: INSERT INTO IEX_STRATEGY_WORK_TEMP_XREF(
300: WORK_TEMP_XREF_ID,
301: STRATEGY_TEMP_ID,
302: WORK_ITEM_TEMP_ID,
303: WORK_ITEM_ORDER,