APPS.PON_AUC_INTERFACE_TABLE_PKG dependencies on PO_PRICE_DIFF_LOOKUPS_V

Line 1384: -- from the po_price_diff_lookups_v values

1380: l_auction_header_id := NULL;
1381: END;
1382:
1383: -- update the interface table with the price_type values
1384: -- from the po_price_diff_lookups_v values
1385: UPDATE pon_auc_price_differ_int papdi
1386: SET price_type = (SELECT Nvl(MAX(ppdl.price_differential_type),'PRICE_TYPE_INVALID')
1387: FROM po_price_diff_lookups_v ppdl
1388: WHERE papdi.price_type_name = ppdl.price_differential_dsp(+)),

Line 1387: FROM po_price_diff_lookups_v ppdl

1383: -- update the interface table with the price_type values
1384: -- from the po_price_diff_lookups_v values
1385: UPDATE pon_auc_price_differ_int papdi
1386: SET price_type = (SELECT Nvl(MAX(ppdl.price_differential_type),'PRICE_TYPE_INVALID')
1387: FROM po_price_diff_lookups_v ppdl
1388: WHERE papdi.price_type_name = ppdl.price_differential_dsp(+)),
1389:
1390: price_type_desc = (SELECT Nvl(MAX(ppdl.price_differential_desc),'PRICE_DESC_INVALID')
1391: FROM po_price_diff_lookups_v ppdl

Line 1391: FROM po_price_diff_lookups_v ppdl

1387: FROM po_price_diff_lookups_v ppdl
1388: WHERE papdi.price_type_name = ppdl.price_differential_dsp(+)),
1389:
1390: price_type_desc = (SELECT Nvl(MAX(ppdl.price_differential_desc),'PRICE_DESC_INVALID')
1391: FROM po_price_diff_lookups_v ppdl
1392: WHERE papdi.price_type_name = ppdl.price_differential_dsp(+))
1393: WHERE batch_id = p_batch_id
1394: AND price_type_name <> 'EMPTY_PRICE_TYPE_NAME';
1395: