DBA Data[Home] [Help]

APPS.PN_VAR_DEFAULTS_PKG dependencies on PN_PAYMENT_SCHEDULES

Line 1553: pn_payment_schedules sched

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
1556: AND term.lease_id = var.lease_id
1557: AND var.var_rent_id = p_var_rent_id

Line 1573: pn_payment_schedules sched

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
1576: AND term.lease_id = var.lease_id
1577: AND var.var_rent_id = p_var_rent_id