APPS.PNRX_RENT_INCREASE_SUMMARY dependencies on PN_INDEX_LEASE_PERIODS_ALL

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

55: --declare all columns as variables here
56:
57: -- declare cursors.....
58: CURSOR cur_carry_forward
59: (p_index_lease_id IN pn_index_lease_periods_all.index_lease_id%TYPE,
60: p_l_precision IN NUMBER) IS
61: SELECT ROUND(carry_forward_amount, p_l_precision) carry_forward_amount,
62: carry_forward_percent,
63: ROUND (constraint_rent_due, p_l_precision) old_rent

Line 64: FROM pn_index_lease_periods_all

60: p_l_precision IN NUMBER) IS
61: SELECT ROUND(carry_forward_amount, p_l_precision) carry_forward_amount,
62: carry_forward_percent,
63: ROUND (constraint_rent_due, p_l_precision) old_rent
64: FROM pn_index_lease_periods_all
65: WHERE index_lease_id = p_index_lease_id
66: AND assessment_date =
67: ADD_MONTHS (
68: term_rec.ilp_assessment_date,

Line 401: pn_index_lease_periods_all ilp'

397: pn_leases_all l,
398: pn_lease_details_all ld,
399: pn_index_leases il ,
400: pn_payment_terms_all it,
401: pn_index_lease_periods_all ilp'
402: || location_code_from
403: || property_name_from
404: || building_name_from
405: || ' WHERE l.lease_id = ld.lease_id