DBA Data[Home] [Help]

APPS.PN_VAR_DEFAULTS_PKG dependencies on PN_PAYMENT_TERMS_ALL

Line 1551: pn_payment_terms_ALL term,

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

Line 1571: pn_payment_terms_ALL term,

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