DBA Data[Home] [Help]

APPS.PON_RESPONSE_IMPORT_PKG dependencies on PON_BID_PAYMENTS_INTERFACE

Line 2188: FROM pon_bid_payments_interface pbpi

2184: AND bai.value IS NOT null))
2185: -- No payments
2186: AND (NOT EXISTS -- no payments
2187: (SELECT pbpi.interface_line_id
2188: FROM pon_bid_payments_interface pbpi
2189: WHERE pbpi.batch_id = bli.batch_id
2190: AND pbpi.document_disp_line_number = al.document_disp_line_number
2191: AND (pbpi.bid_currency_price IS NOT NULL
2192: OR pbpi.promised_date IS NOT NULL)

Line 2260: DELETE FROM pon_bid_payments_interface pbpi

2256: where bli.batch_id = p_batch_id
2257: AND bli.interface_line_id = g_skip_int);
2258:
2259: -- Delete from payments interface table
2260: DELETE FROM pon_bid_payments_interface pbpi
2261: WHERE pbpi.batch_id = p_batch_id
2262: AND pbpi.document_disp_line_number in (
2263: select pai.document_disp_line_number
2264: from pon_bid_item_prices_interface bli,