APPS.PNRX_RENT_INCREASE_DETAIL dependencies on PN_INDEX_LEASE_PERIODS_ALL

Line 85: (p_index_lease_id IN pn_index_lease_periods_all.index_lease_id%TYPE,

81:
82: -- declare cursors.....
83:
84: CURSOR cur_carry_forward
85: (p_index_lease_id IN pn_index_lease_periods_all.index_lease_id%TYPE,
86: p_l_precision IN NUMBER) IS
87: SELECT ROUND(carry_forward_amount, p_l_precision) carry_forward_amount,
88: carry_forward_percent,
89: ROUND (constraint_rent_due, p_l_precision) old_rent

Line 90: FROM pn_index_lease_periods_all

86: p_l_precision IN NUMBER) IS
87: SELECT ROUND(carry_forward_amount, p_l_precision) carry_forward_amount,
88: carry_forward_percent,
89: ROUND (constraint_rent_due, p_l_precision) old_rent
90: FROM pn_index_lease_periods_all
91: WHERE index_lease_id = p_index_lease_id
92: AND assessment_date =
93: ADD_MONTHS (
94: term_rec.ilp_assessment_date,

Line 468: pn_index_lease_periods_all ilp'

464: pn_payment_terms_all it,
465: pn_leases_all l,
466: pn_lease_details_all ld,
467: pn_index_leases il ,
468: pn_index_lease_periods_all ilp'
469: || location_code_from
470: || property_name_from
471: || building_name_from
472: || ' WHERE it.lease_id = l.lease_id