1547:
1548: SELECT sum(item.ACTUAL_AMOUNT)
1549: INTO l_base_rent
1550: FROM pn_payment_items_ALL item,
1551: pn_payment_terms_ALL term,
1552: pn_var_rents_ALL var,
1553: pn_payment_schedules sched
1554: WHERE item.PAYMENT_TERM_ID = term.PAYMENT_TERM_ID
1555: AND sched.PAYMENT_SCHEDULE_ID = item.PAYMENT_SCHEDULE_ID
1567:
1568: SELECT sum(item.ACTUAL_AMOUNT)
1569: INTO l_base_rent
1570: FROM pn_payment_items_ALL item,
1571: pn_payment_terms_ALL term,
1572: pn_var_rents_ALL var,
1573: pn_payment_schedules sched
1574: WHERE item.PAYMENT_TERM_ID = term.PAYMENT_TERM_ID
1575: AND sched.PAYMENT_SCHEDULE_ID = item.PAYMENT_SCHEDULE_ID