DBA Data[Home] [Help]

APPS.CSM_CURRENCY_EVENT_PKG dependencies on DUAL

Line 56: select csm_currencies_acc_s.NEXTVAL from dual;

52: OR (curr_tl.creation_date < p_last_upd_date AND curr_tl.last_update_date > p_last_upd_date)
53: );
54:
55: CURSOR l_access_id_csr IS
56: select csm_currencies_acc_s.NEXTVAL from dual;
57:
58: l_mark_dirty boolean;
59: l_curr_last_update_date fnd_currencies.LAST_UPDATE_DATE%TYPE;
60: l_curr_tl_last_update_date fnd_currencies.LAST_UPDATE_DATE%TYPE;

Line 200: -- select csm_currencies_acc_s.NEXTVAL into l_access_id from dual;

196: FETCH l_inserts_cur INTO l_currency_code, l_curr_last_update_date;
197: EXIT WHEN l_inserts_cur%NOTFOUND;
198:
199: --generate access_id
200: -- select csm_currencies_acc_s.NEXTVAL into l_access_id from dual;
201: OPEN l_access_id_csr;
202: FETCH l_access_id_csr INTO l_access_id;
203: CLOSE l_access_id_csr;
204: --mark dirty the SDQ for all users