DBA Data[Home] [Help]

APPS.CN_LEDGER_JOURNAL_ENTRIES_API dependencies on DUAL

Line 51: SELECT cn_ledger_journal_entries_s.currval INTO JE_Return FROM dual;

47: WHERE salesrep_id = X_salesrep_id
48: AND period_id = X_period_id
49: AND batch.batch_id = X_batch_id);
50:
51: SELECT cn_ledger_journal_entries_s.currval INTO JE_Return FROM dual;
52:
53: RETURN JE_Return;
54:
55: END New_JE;

Line 112: SELECT cn_ledger_journal_entries_s.CURRVAL INTO JE_Return FROM dual;

108: AND batch.batch_id = X_batch_id);
109:
110: --dbms_output.put_line('Insert ...' || SQL%rowcount);
111:
112: SELECT cn_ledger_journal_entries_s.CURRVAL INTO JE_Return FROM dual;
113:
114: RETURN JE_Return;
115:
116: END New_JE;

Line 149: SELECT cn_ledger_journal_entries_s.currval INTO JE_Return FROM dual;

145: FROM cn_srp_periods srp_per
146: WHERE salesrep_id = X_salesrep_id
147: AND period_id = X_period_id);
148:
149: SELECT cn_ledger_journal_entries_s.currval INTO JE_Return FROM dual;
150:
151: RETURN JE_Return;
152:
153: END New_JE;