APPS.PN_INDEX_HISTORY_LINES_PKG dependencies on DUAL

Line 76: FROM DUAL;

72: -- If no INDEX_LINE_ID is provided, get one from sequence
73: IF (x_index_line_id IS NULL) THEN
74: SELECT pn_index_history_lines_s.NEXTVAL
75: INTO x_index_line_id
76: FROM DUAL;
77: END IF;
78:
79: check_unq_index_line (l_return_status, x_index_id, x_index_line_id, x_index_date);
80:

Line 377: FROM DUAL

373: l_dummy NUMBER;
374: BEGIN
375: SELECT 1
376: INTO l_dummy
377: FROM DUAL
378: WHERE NOT EXISTS ( SELECT 1
379: FROM pn_index_history_lines
380: WHERE (TO_CHAR (index_date, 'MON-RRRR') =
381: TO_CHAR (x_index_date, 'MON-RRRR')