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.PN_INDEX_LEASE_COMMON_PKG dependencies on PN_INDEX_LEASE_PERIODS

Line 181: current_basis pn_index_lease_periods.current_basis%TYPE

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

Line 182: ,constraint_rent_due pn_index_lease_periods.constraint_rent_due%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

Line 183: ,unconstraint_rent_due pn_index_lease_periods.unconstraint_rent_due%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

Line 184: ,index_percent_change pn_index_lease_periods.index_percent_change%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);

Line 185: ,current_index_line_id pn_index_lease_periods.current_index_line_id%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:

Line 186: ,current_index_line_value pn_index_lease_periods.current_index_line_value%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:
190:

Line 187: ,previous_index_line_id pn_index_lease_periods.previous_index_line_id%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:
191: ------------------------------------------------------------------------

Line 188: ,previous_index_line_value pn_index_lease_periods.previous_index_line_value%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: ------------------------------------------------------------------------
192: -- PROCEDURE : GET_INDEX_PERIOD_DETAILS