APPS.PON_OPEN_INTERFACE_PVT dependencies on PO_PRICE_DIFF_LOOKUPS_V

Line 3367: SET price_type = (SELECT price_type FROM po_price_diff_lookups_v WHERE price_type_name = diff.price_type )

3363: AND papbi.AUCTION_HEADER_ID = p_auction_header_id
3364: AND PAIP.LINE_NUMBER = papbi.auction_LINE_NUMBER;
3365:
3366: UPDATE pon_auc_price_differ_int diff
3367: SET price_type = (SELECT price_type FROM po_price_diff_lookups_v WHERE price_type_name = diff.price_type )
3368: WHERE diff.auction_header_id = p_auction_header_id
3369: AND diff.price_type_name IS NOT null;
3370:
3371: INSERT ALL

Line 3408: OR NOT EXISTS (SELECT 1 FROM po_price_diff_lookups_v WHERE price_differential_type = sel_price_type))

3404: sysdate , -- LAST_UPDATE_DATE
3405: p_login_id -- LAST_UPDATE_LOGIN
3406: )
3407: WHEN (sel_price_type IS NULL
3408: OR NOT EXISTS (SELECT 1 FROM po_price_diff_lookups_v WHERE price_differential_type = sel_price_type))
3409: THEN INTO PON_INTERFACE_ERRORS
3410: (
3411: INTERFACE_TYPE ,
3412: ERROR_MESSAGE_NAME,