DBA Data[Home] [Help]

APPS.PN_VAR_DEFAULTS_PKG dependencies on PN_PAYMENT_ITEMS_ALL

Line 1550: FROM pn_payment_items_ALL item,

1546: IF (p_base_rent_type = 'ROLLING') THEN
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

Line 1570: FROM pn_payment_items_ALL item,

1566: ELSIF (p_base_rent_type = 'FIXED') THEN
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