APPS.OZF_THRESHOLD_PVT dependencies on DUAL

Line 965: FROM DUAL;

961: AND c.end_date >= SYSDATE;
962:
963: CURSOR c_log_seq IS
964: SELECT ams_act_logs_s.NEXTVAL
965: FROM DUAL;
966:
967: CURSOR c_trans_seq IS
968: SELECT ams_act_logs_transaction_id_s.NEXTVAL
969: FROM DUAL;

Line 969: FROM DUAL;

965: FROM DUAL;
966:
967: CURSOR c_trans_seq IS
968: SELECT ams_act_logs_transaction_id_s.NEXTVAL
969: FROM DUAL;
970:
971:
972: CURSOR c_log_message (p_trans_id NUMBER)
973: IS

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

1146: OPEN c_valuelimit_name(budget.value_limit);
1147: FETCH c_valuelimit_name INTO l_valuelimit_name;
1148: CLOSE c_valuelimit_name;
1149:
1150: select to_char(sysdate, 'dd-Mon-yyyy' ) into l_today_date from dual;
1151:
1152: fnd_message.set_name ('OZF', 'OZF_WF_NTF_THRESHOLD_FYI');
1153: fnd_message.set_token ('BUDGET_NAME', l_budget_name, FALSE);
1154: fnd_message.set_token ('VALUE_LIMIT', l_valuelimit_name, FALSE);