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 330: select IEX_STRATEGY_WORK_TEMP_XREF_S.NEXTVAL

326:
327: IEX_DEBUG_PUB.logmessage('Copy XRef for Template = ' || tempCur.STRATEGY_TEMP_ID ||
328: ' and Xref ID = ' || xrefCur.WORK_TEMP_XREF_ID );
329:
330: select IEX_STRATEGY_WORK_TEMP_XREF_S.NEXTVAL
331: into nNextXrefID FROM DUAL;
332:
333: IEX_DEBUG_PUB.logmessage('Next Work Item Xref ID from seq = ' || nNextXrefID);
334:

Line 335: INSERT INTO IEX_STRATEGY_WORK_TEMP_XREF(

331: into nNextXrefID FROM DUAL;
332:
333: IEX_DEBUG_PUB.logmessage('Next Work Item Xref ID from seq = ' || nNextXrefID);
334:
335: INSERT INTO IEX_STRATEGY_WORK_TEMP_XREF(
336: WORK_TEMP_XREF_ID,
337: STRATEGY_TEMP_ID,
338: WORK_ITEM_TEMP_ID,
339: WORK_ITEM_ORDER,