APPS.PN_OPEX_TERMS_PKG dependencies on PN_PAYMENT_ITEMS_ALL

Line 1201: DELETE FROM pn_payment_items_all

1197: l_sch_id := sch_rec.payment_schedule_id;
1198:
1199: pnp_debug_pkg.put_log_msg('Deleting Schedule_id ' || l_sch_id);
1200:
1201: DELETE FROM pn_payment_items_all
1202: WHERE payment_term_id = prev_pay_term_id
1203: AND payment_schedule_id = l_sch_id
1204: AND payment_item_type_lookup_code = 'CASH';
1205:

Line 1208: FROM pn_payment_items_all

1204: AND payment_item_type_lookup_code = 'CASH';
1205:
1206: DELETE FROM pn_payment_schedules_all
1207: WHERE NOT EXISTS (SELECT NULL
1208: FROM pn_payment_items_all
1209: WHERE payment_schedule_id = l_sch_id)
1210: AND payment_schedule_id = l_sch_id;
1211:
1212: END LOOP; /*sch cursor */

Line 2319: FROM pn_payment_items_all item,

2315:
2316: CURSOR amt_cur(c_recon_id IN NUMBER) IS
2317:
2318: SELECT SUM(item.actual_amount) act_amt
2319: FROM pn_payment_items_all item,
2320: pn_payment_terms_all term,
2321: pn_opex_recon_all recon
2322: WHERE item.payment_item_type_lookup_code = 'CASH'
2323: AND item.payment_term_id = term.payment_term_id