APPS.CSI_ML_CREATE_PUB dependencies on DUAL

Line 72: FROM dual;

68: -- commit;
69:
70: SELECT nvl(FND_PROFILE.VALUE('CSI_OPEN_INTERFACE_COMMIT_RECS'),1000)
71: INTO l_commit_recs
72: FROM dual;
73: l_txn_from_date := to_date(p_txn_from_date, 'YYYY/MM/DD HH24:MI:SS');
74: l_txn_to_date := to_date(p_txn_to_date, 'YYYY/MM/DD HH24:MI:SS');
75: -- get the number of records and fiqure out how many loops to do
76: SELECT ceil(count(1)/l_commit_recs)

Line 348: FROM dual;

344: -- commit;
345:
346: SELECT nvl(FND_PROFILE.VALUE('CSI_OPEN_INTERFACE_COMMIT_RECS'),1000)
347: INTO l_commit_recs
348: FROM dual;
349:
350: FND_File.Put_Line(Fnd_File.LOG,'After Commit Profile: '||
351: to_char(sysdate,'DD-MON-YYYY HH:MI:SS:SS'));
352: