APPS.PNT_PAYMENT_TERMS_PKG dependencies on PN_PAYMENT_SCHEDULES_ALL

Line 1577: FROM pn_payment_schedules_all pps

1573: WHERE lease_id = x_lease_id
1574: AND EXISTS
1575: (
1576: SELECT pps.lease_id
1577: FROM pn_payment_schedules_all pps
1578: WHERE pps.lease_id = x_lease_id
1579: AND pps.payment_status_lookup_code = 'APPROVED'
1580: AND TO_CHAR(pps.schedule_date, 'DD') = x_schedule_day
1581: AND pps.schedule_date BETWEEN l_startDate AND l_endDate

Line 1663: pn_payment_schedules_all pps

1659: , ppi.estimated_amount
1660: , pps.schedule_date
1661: , ppi.currency_code
1662: FROM pn_payment_items_all ppi,
1663: pn_payment_schedules_all pps
1664: WHERE ppi.payment_term_id = p_pnt_term_id
1665: AND ppi.payment_item_type_lookup_code = 'CASH'
1666: AND pps.payment_schedule_id = ppi.payment_schedule_id
1667: AND pps.payment_status_lookup_code = 'DRAFT';