DBA Data[Home] [Help]

APPS.PON_RESPONSE_IMPORT_PKG dependencies on PON_BID_PAYMENTS_INTERFACE

Line 2401: FROM pon_bid_payments_interface pbpi

2397: AND bai.value IS NOT null))
2398: -- No payments
2399: AND (NOT EXISTS -- no payments
2400: (SELECT pbpi.interface_line_id
2401: FROM pon_bid_payments_interface pbpi
2402: WHERE pbpi.batch_id = bli.batch_id
2403: AND pbpi.document_disp_line_number = al.document_disp_line_number
2404: AND (pbpi.bid_currency_price IS NOT NULL
2405: OR pbpi.promised_date IS NOT NULL)

Line 2473: DELETE FROM pon_bid_payments_interface pbpi

2469: where bli.batch_id = p_batch_id
2470: AND bli.interface_line_id = g_skip_int);
2471:
2472: -- Delete from payments interface table
2473: DELETE FROM pon_bid_payments_interface pbpi
2474: WHERE pbpi.batch_id = p_batch_id
2475: AND pbpi.document_disp_line_number in (
2476: select pai.document_disp_line_number
2477: from pon_bid_item_prices_interface bli,