DBA Data[Home] [Help]

APPS.PN_INDEX_LEASE_COMMON_PKG dependencies on PN_INDEX_HISTORY_HEADERS

Line 315: FROM pn_index_history_lines lines, pn_index_history_headers headers

311: BEGIN
312: BEGIN
313: SELECT lines.index_figure
314: INTO v_base_index
315: FROM pn_index_history_lines lines, pn_index_history_headers headers
316: WHERE lines.index_id = headers.index_id
317: AND TO_CHAR (lines.index_date, 'MON-RRRR') = TO_CHAR (p_base_year, 'MON-RRRR')
318: AND lines.index_id = p_index_id;
319: EXCEPTION