APPS.PNT_PAYMENT_TERMS_PKG dependencies on PN_PAYMENT_SCHEDULES_ALL

Line 1573: FROM pn_payment_schedules_all pps

1569: WHERE lease_id = x_lease_id
1570: AND EXISTS
1571: (
1572: SELECT pps.lease_id
1573: FROM pn_payment_schedules_all pps
1574: WHERE pps.lease_id = x_lease_id
1575: AND pps.payment_status_lookup_code = 'APPROVED'
1576: AND TO_CHAR(pps.schedule_date, 'DD') = x_schedule_day
1577: AND pps.schedule_date BETWEEN l_startDate AND l_endDate

Line 1659: pn_payment_schedules_all pps

1655: , ppi.estimated_amount
1656: , pps.schedule_date
1657: , ppi.currency_code
1658: FROM pn_payment_items_all ppi,
1659: pn_payment_schedules_all pps
1660: WHERE ppi.payment_term_id = p_pnt_term_id
1661: AND ppi.payment_item_type_lookup_code = 'CASH'
1662: AND pps.payment_schedule_id = ppi.payment_schedule_id
1663: AND pps.payment_status_lookup_code = 'DRAFT';