APPS.PN_VAR_RENT_CALC_PKG dependencies on PN_VAR_RENTS_ALL

Line 98: pn_var_rents_all vr

94: ,vr.proration_rule
95: ,vr.cumulative_vol
96: ,vr.negative_rent
97: FROM
98: pn_var_rents_all vr
99: WHERE
100: vr.var_rent_id = p_vr_id;
101:
102: /* get trx headers */

Line 213: g_org_id pn_var_rents_all.org_id%TYPE;

209: );
210:
211: TYPE TRX_HDR_RENT_TBL IS TABLE OF TRX_HDR_RENT_REC INDEX BY BINARY_INTEGER;
212:
213: g_org_id pn_var_rents_all.org_id%TYPE;
214: g_vr_commencement_date pn_var_rents_all.commencement_date%TYPE;
215: g_vr_termination_date pn_var_rents_all.termination_date%TYPE;
216: g_proration_rule pn_var_rents_all.proration_rule%TYPE;
217: g_calculation_method pn_var_rents_all.cumulative_vol%TYPE;

Line 214: g_vr_commencement_date pn_var_rents_all.commencement_date%TYPE;

210:
211: TYPE TRX_HDR_RENT_TBL IS TABLE OF TRX_HDR_RENT_REC INDEX BY BINARY_INTEGER;
212:
213: g_org_id pn_var_rents_all.org_id%TYPE;
214: g_vr_commencement_date pn_var_rents_all.commencement_date%TYPE;
215: g_vr_termination_date pn_var_rents_all.termination_date%TYPE;
216: g_proration_rule pn_var_rents_all.proration_rule%TYPE;
217: g_calculation_method pn_var_rents_all.cumulative_vol%TYPE;
218: g_negative_rent pn_var_rents_all.negative_rent%TYPE;

Line 215: g_vr_termination_date pn_var_rents_all.termination_date%TYPE;

211: TYPE TRX_HDR_RENT_TBL IS TABLE OF TRX_HDR_RENT_REC INDEX BY BINARY_INTEGER;
212:
213: g_org_id pn_var_rents_all.org_id%TYPE;
214: g_vr_commencement_date pn_var_rents_all.commencement_date%TYPE;
215: g_vr_termination_date pn_var_rents_all.termination_date%TYPE;
216: g_proration_rule pn_var_rents_all.proration_rule%TYPE;
217: g_calculation_method pn_var_rents_all.cumulative_vol%TYPE;
218: g_negative_rent pn_var_rents_all.negative_rent%TYPE;
219: /* --------------------------------------------------------------------------

Line 216: g_proration_rule pn_var_rents_all.proration_rule%TYPE;

212:
213: g_org_id pn_var_rents_all.org_id%TYPE;
214: g_vr_commencement_date pn_var_rents_all.commencement_date%TYPE;
215: g_vr_termination_date pn_var_rents_all.termination_date%TYPE;
216: g_proration_rule pn_var_rents_all.proration_rule%TYPE;
217: g_calculation_method pn_var_rents_all.cumulative_vol%TYPE;
218: g_negative_rent pn_var_rents_all.negative_rent%TYPE;
219: /* --------------------------------------------------------------------------
220: ------------------------ PROCEDURES AND FUNCTIONS ------------------------

Line 217: g_calculation_method pn_var_rents_all.cumulative_vol%TYPE;

213: g_org_id pn_var_rents_all.org_id%TYPE;
214: g_vr_commencement_date pn_var_rents_all.commencement_date%TYPE;
215: g_vr_termination_date pn_var_rents_all.termination_date%TYPE;
216: g_proration_rule pn_var_rents_all.proration_rule%TYPE;
217: g_calculation_method pn_var_rents_all.cumulative_vol%TYPE;
218: g_negative_rent pn_var_rents_all.negative_rent%TYPE;
219: /* --------------------------------------------------------------------------
220: ------------------------ PROCEDURES AND FUNCTIONS ------------------------
221: -------------------------------------------------------------------------- */

Line 218: g_negative_rent pn_var_rents_all.negative_rent%TYPE;

214: g_vr_commencement_date pn_var_rents_all.commencement_date%TYPE;
215: g_vr_termination_date pn_var_rents_all.termination_date%TYPE;
216: g_proration_rule pn_var_rents_all.proration_rule%TYPE;
217: g_calculation_method pn_var_rents_all.cumulative_vol%TYPE;
218: g_negative_rent pn_var_rents_all.negative_rent%TYPE;
219: /* --------------------------------------------------------------------------
220: ------------------------ PROCEDURES AND FUNCTIONS ------------------------
221: -------------------------------------------------------------------------- */
222: