177: RETURN VARCHAR2;
178:
179:
180: TYPE index_lease_periods_rec IS RECORD (
181: current_basis pn_index_lease_periods.current_basis%TYPE
182: ,constraint_rent_due pn_index_lease_periods.constraint_rent_due%TYPE
183: ,unconstraint_rent_due pn_index_lease_periods.unconstraint_rent_due%TYPE
184: ,index_percent_change pn_index_lease_periods.index_percent_change%TYPE
185: ,current_index_line_id pn_index_lease_periods.current_index_line_id%TYPE
178:
179:
180: TYPE index_lease_periods_rec IS RECORD (
181: current_basis pn_index_lease_periods.current_basis%TYPE
182: ,constraint_rent_due pn_index_lease_periods.constraint_rent_due%TYPE
183: ,unconstraint_rent_due pn_index_lease_periods.unconstraint_rent_due%TYPE
184: ,index_percent_change pn_index_lease_periods.index_percent_change%TYPE
185: ,current_index_line_id pn_index_lease_periods.current_index_line_id%TYPE
186: ,current_index_line_value pn_index_lease_periods.current_index_line_value%TYPE
179:
180: TYPE index_lease_periods_rec IS RECORD (
181: current_basis pn_index_lease_periods.current_basis%TYPE
182: ,constraint_rent_due pn_index_lease_periods.constraint_rent_due%TYPE
183: ,unconstraint_rent_due pn_index_lease_periods.unconstraint_rent_due%TYPE
184: ,index_percent_change pn_index_lease_periods.index_percent_change%TYPE
185: ,current_index_line_id pn_index_lease_periods.current_index_line_id%TYPE
186: ,current_index_line_value pn_index_lease_periods.current_index_line_value%TYPE
187: ,previous_index_line_id pn_index_lease_periods.previous_index_line_id%TYPE
180: TYPE index_lease_periods_rec IS RECORD (
181: current_basis pn_index_lease_periods.current_basis%TYPE
182: ,constraint_rent_due pn_index_lease_periods.constraint_rent_due%TYPE
183: ,unconstraint_rent_due pn_index_lease_periods.unconstraint_rent_due%TYPE
184: ,index_percent_change pn_index_lease_periods.index_percent_change%TYPE
185: ,current_index_line_id pn_index_lease_periods.current_index_line_id%TYPE
186: ,current_index_line_value pn_index_lease_periods.current_index_line_value%TYPE
187: ,previous_index_line_id pn_index_lease_periods.previous_index_line_id%TYPE
188: ,previous_index_line_value pn_index_lease_periods.previous_index_line_value%TYPE);
181: current_basis pn_index_lease_periods.current_basis%TYPE
182: ,constraint_rent_due pn_index_lease_periods.constraint_rent_due%TYPE
183: ,unconstraint_rent_due pn_index_lease_periods.unconstraint_rent_due%TYPE
184: ,index_percent_change pn_index_lease_periods.index_percent_change%TYPE
185: ,current_index_line_id pn_index_lease_periods.current_index_line_id%TYPE
186: ,current_index_line_value pn_index_lease_periods.current_index_line_value%TYPE
187: ,previous_index_line_id pn_index_lease_periods.previous_index_line_id%TYPE
188: ,previous_index_line_value pn_index_lease_periods.previous_index_line_value%TYPE);
189:
182: ,constraint_rent_due pn_index_lease_periods.constraint_rent_due%TYPE
183: ,unconstraint_rent_due pn_index_lease_periods.unconstraint_rent_due%TYPE
184: ,index_percent_change pn_index_lease_periods.index_percent_change%TYPE
185: ,current_index_line_id pn_index_lease_periods.current_index_line_id%TYPE
186: ,current_index_line_value pn_index_lease_periods.current_index_line_value%TYPE
187: ,previous_index_line_id pn_index_lease_periods.previous_index_line_id%TYPE
188: ,previous_index_line_value pn_index_lease_periods.previous_index_line_value%TYPE);
189:
190:
183: ,unconstraint_rent_due pn_index_lease_periods.unconstraint_rent_due%TYPE
184: ,index_percent_change pn_index_lease_periods.index_percent_change%TYPE
185: ,current_index_line_id pn_index_lease_periods.current_index_line_id%TYPE
186: ,current_index_line_value pn_index_lease_periods.current_index_line_value%TYPE
187: ,previous_index_line_id pn_index_lease_periods.previous_index_line_id%TYPE
188: ,previous_index_line_value pn_index_lease_periods.previous_index_line_value%TYPE);
189:
190:
191: ------------------------------------------------------------------------
184: ,index_percent_change pn_index_lease_periods.index_percent_change%TYPE
185: ,current_index_line_id pn_index_lease_periods.current_index_line_id%TYPE
186: ,current_index_line_value pn_index_lease_periods.current_index_line_value%TYPE
187: ,previous_index_line_id pn_index_lease_periods.previous_index_line_id%TYPE
188: ,previous_index_line_value pn_index_lease_periods.previous_index_line_value%TYPE);
189:
190:
191: ------------------------------------------------------------------------
192: -- PROCEDURE : GET_INDEX_PERIOD_DETAILS