APPS.BOM_CSTRSCCR_XMLP_PKG dependencies on DUAL

Line 136: DUAL;

132: NVL(FND_PROFILE.VALUE('CST_RU_PHANTOM_MATERIAL')
133: ,1)
134: INTO P_PHANTOM_MAT
135: FROM
136: DUAL;
137: L_STMT_NUM := 30;
138: IF P_ROLLUP_ID IS NOT NULL THEN
139: L_RERUN_FLAG := 1;
140: L_STMT_NUM := 40;

Line 177: DUAL;

173: SELECT
174: CST_LISTS_S.NEXTVAL
175: INTO P_ROLLUP_ID
176: FROM
177: DUAL;
178: L_STMT_NUM := 60;
179: IF (P_REPORT_OPTION_TYPE <> -1) THEN
180: INSERT INTO CST_SC_ROLLUP_HISTORY
181: (ROLLUP_ID

Line 306: DUAL;

302: TO_CHAR(SYSDATE
303: ,'YYYY/MM/DD HH24:MI:ss')
304: INTO LP_REVISION_DATE
305: FROM
306: DUAL;
307: END IF;
308: L_STMT_NUM := 100;
309: SELECT
310: CCT1.COST_TYPE,

Line 757: DUAL;

753: SELECT
754: sysdate
755: INTO L_TIMESTAMP
756: FROM
757: DUAL;
758: /*SRW.MESSAGE(0
759: ,'Before CSTPSCEX.supply_chain_rollup ' || TO_CHAR(L_TIMESTAMP
760: ,'YYYY/MM/DD HH24:MI:SS'))*/NULL;
761: L_STMT_NUM := 230;

Line 793: DUAL;

789: SELECT
790: sysdate
791: INTO L_TIMESTAMP
792: FROM
793: DUAL;
794: /*SRW.MESSAGE(0
795: ,'After CSTPSCEX.supply_chain_rollup ' || TO_CHAR(L_TIMESTAMP
796: ,'YYYY/MM/DD HH24:MI:SS'))*/NULL;
797: L_STMT_NUM := 250;