APPS.PN_INDEX_LEASE_COMMON_PKG dependencies on PN_INDEX_HISTORY_LINES

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

Line 505: FROM pn_index_history_lines

501: v CHAR (1) := 0;
502:
503: CURSOR c IS
504: SELECT *
505: FROM pn_index_history_lines
506: WHERE index_line_id = p_index_line_id;
507: BEGIN
508: FOR c_rec IN c
509: LOOP

Line 901: v_index_line_id pn_index_history_lines.index_line_id%TYPE;

897: ,p_index_finder_date IN DATE
898: ,op_cpi_value OUT NOCOPY NUMBER
899: ,op_cpi_id OUT NOCOPY NUMBER
900: ,op_msg OUT NOCOPY VARCHAR2) IS
901: v_index_line_id pn_index_history_lines.index_line_id%TYPE;
902: v_index_figure pn_index_history_lines.index_figure%TYPE;
903: BEGIN
904: --put_log ('..In lookup_index_history');
905: --

Line 902: v_index_figure pn_index_history_lines.index_figure%TYPE;

898: ,op_cpi_value OUT NOCOPY NUMBER
899: ,op_cpi_id OUT NOCOPY NUMBER
900: ,op_msg OUT NOCOPY VARCHAR2) IS
901: v_index_line_id pn_index_history_lines.index_line_id%TYPE;
902: v_index_figure pn_index_history_lines.index_figure%TYPE;
903: BEGIN
904: --put_log ('..In lookup_index_history');
905: --
906: -- Do a lookup on index history using finder date

Line 912: FROM pn_index_history_lines phl

908: SELECT phl.index_line_id
909: ,phl.index_figure
910: INTO v_index_line_id
911: ,v_index_figure
912: FROM pn_index_history_lines phl
913: WHERE phl.index_id = p_index_history_id
914: AND TO_CHAR (phl.index_date, 'Mm-YYYY') =
915: TO_CHAR (p_index_finder_date, 'Mm-YYYY');
916: --

Line 1185: ,pn_index_history_lines lines

1181: INTO l_hist_line_used
1182: FROM DUAL
1183: WHERE EXISTS ( SELECT periods.previous_index_line_id
1184: FROM pn_index_lease_periods_all periods
1185: ,pn_index_history_lines lines
1186: WHERE periods.previous_index_line_id = lines.index_line_id
1187: AND lines.index_line_id = p_index_line_id);
1188: RETURN l_hist_line_used;
1189: EXCEPTION

Line 1203: ,pn_index_history_lines lines

1199: INTO l_hist_line_used
1200: FROM DUAL
1201: WHERE EXISTS ( SELECT periods.current_index_line_id
1202: FROM pn_index_lease_periods_all periods
1203: ,pn_index_history_lines lines
1204: WHERE periods.current_index_line_id = lines.index_line_id
1205: AND lines.index_line_id = p_index_line_id);
1206: RETURN l_hist_line_used;
1207: EXCEPTION