APPS.PN_OPEX_TERMS_PKG dependencies on PN_PAYMENT_ITEMS_ALL

Line 1192: from pn_payment_items_all

1188: prev_trm_end_date := opex_est_pay_rec.start_date;
1189:
1190: select count(1)
1191: into l_approved_item_count
1192: from pn_payment_items_all
1193: where payment_term_id = prev_pay_term_id
1194: and nvl(export_to_ap_flag,'N') = 'Y'
1195: and payment_item_type_lookup_code = 'CASH';
1196:

Line 1213: DELETE FROM pn_payment_items_all

1209: l_sch_id := sch_rec.payment_schedule_id;
1210:
1211: pnp_debug_pkg.put_log_msg('Deleting Schedule_id ' || l_sch_id);
1212:
1213: DELETE FROM pn_payment_items_all
1214: WHERE payment_term_id = prev_pay_term_id
1215: AND payment_schedule_id = l_sch_id
1216: AND payment_item_type_lookup_code = 'CASH';
1217:

Line 1220: FROM pn_payment_items_all

1216: AND payment_item_type_lookup_code = 'CASH';
1217:
1218: DELETE FROM pn_payment_schedules_all
1219: WHERE NOT EXISTS (SELECT NULL
1220: FROM pn_payment_items_all
1221: WHERE payment_schedule_id = l_sch_id)
1222: AND payment_schedule_id = l_sch_id;
1223:
1224: END LOOP; /*sch cursor */

Line 2350: FROM pn_payment_items_all item,

2346:
2347: CURSOR amt_cur(c_recon_id IN NUMBER) IS
2348:
2349: SELECT SUM(item.actual_amount) act_amt
2350: FROM pn_payment_items_all item,
2351: pn_payment_terms_all term,
2352: pn_opex_recon_all recon
2353: WHERE item.payment_item_type_lookup_code = 'CASH'
2354: AND item.payment_term_id = term.payment_term_id