APPS.PNRX_RENT_INCREASE_DETAILACC dependencies on PN_INDEX_LEASE_PERIODS_ALL

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

63: --declare all columns as variables here
64:
65: -- declare cursors.....
66: CURSOR cur_carry_forward
67: (p_index_lease_id IN pn_index_lease_periods_all.index_lease_id%TYPE,
68: p_l_precision IN NUMBER) IS
69: SELECT ROUND(carry_forward_amount, p_l_precision) carry_forward_amount,
70: carry_forward_percent,
71: ROUND (constraint_rent_due, p_l_precision) old_rent

Line 72: FROM pn_index_lease_periods_all

68: p_l_precision IN NUMBER) IS
69: SELECT ROUND(carry_forward_amount, p_l_precision) carry_forward_amount,
70: carry_forward_percent,
71: ROUND (constraint_rent_due, p_l_precision) old_rent
72: FROM pn_index_lease_periods_all
73: WHERE index_lease_id = p_index_lease_id
74: AND assessment_date =
75: ADD_MONTHS (
76: term_rec.ilp_assessment_date,

Line 458: pn_index_lease_periods_all ilp'

454: pn_leases_all l,
455: pn_lease_details_all ld,
456: pn_index_leases il ,
457: pn_distributions_all dist,
458: pn_index_lease_periods_all ilp'
459: || location_code_from
460: || property_name_from
461: || building_name_from
462: || ' WHERE it.lease_id = l.lease_id