eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PON_REMINDER_NOTIFICATION_PKG dependencies on DUAL

Line 203: FROM dual;

199:
200: IF p_send_when = g_before_close_date
201: THEN
202: SELECT Floor(c_neg_details.close_bidding_date - l_temp_sys_date) INTO l_diff_days
203: FROM dual;
204: ELSIF p_send_when = g_after_open_date
205: THEN
206: SELECT Floor(l_temp_sys_date - c_neg_details.open_bidding_date) INTO l_diff_days
207: FROM dual;

Line 207: FROM dual;

203: FROM dual;
204: ELSIF p_send_when = g_after_open_date
205: THEN
206: SELECT Floor(l_temp_sys_date - c_neg_details.open_bidding_date) INTO l_diff_days
207: FROM dual;
208: ELSIF p_send_when = g_after_preview_date
209: THEN
210: SELECT Floor(l_temp_sys_date - c_neg_details.preview_date) INTO l_diff_days
211: FROM dual;

Line 211: FROM dual;

207: FROM dual;
208: ELSIF p_send_when = g_after_preview_date
209: THEN
210: SELECT Floor(l_temp_sys_date - c_neg_details.preview_date) INTO l_diff_days
211: FROM dual;
212: END IF;
213:
214: IF(g_debug_enabled = 'Y') then
215: x_progress := ++l_progress || l_api_name || ' : difference of days calculated, l_diff_days = ' || l_diff_days;