APPS.OZF_QUOTA_THRESHOLD_PVT dependencies on DUAL

Line 306: FROM DUAL;

302: ORDER BY sequence_number;
303:
304: CURSOR c_log_seq IS
305: SELECT ams_act_logs_s.NEXTVAL
306: FROM DUAL;
307:
308: CURSOR c_trans_seq IS
309: SELECT ams_act_logs_transaction_id_s.NEXTVAL
310: FROM DUAL;

Line 310: FROM DUAL;

306: FROM DUAL;
307:
308: CURSOR c_trans_seq IS
309: SELECT ams_act_logs_transaction_id_s.NEXTVAL
310: FROM DUAL;
311:
312:
313: CURSOR c_log_message (p_trans_id NUMBER)
314: IS

Line 801: select to_char(sysdate, 'dd-Mon-yyyy' ) into l_today_date from dual;

797: OPEN c_valuelimit_name(budget.value_limit);
798: FETCH c_valuelimit_name INTO l_valuelimit_name;
799: CLOSE c_valuelimit_name;
800:
801: select to_char(sysdate, 'dd-Mon-yyyy' ) into l_today_date from dual;
802:
803: IF budget.comparison_type = 'PERCENT' then
804: OPEN c_baseline_name(budget.base_line);
805: FETCH c_baseline_name INTO l_baseline_name;

Line 1272: FROM DUAL;

1268: l_update BOOLEAN;
1269:
1270: CURSOR c_quota_alert_seq IS
1271: SELECT ozf_quota_alerts_s.NEXTVAL
1272: FROM DUAL;
1273:
1274: BEGIN
1275: -- Standard call to check for call compatibility.
1276: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,