APPS.PON_AUC_INTERFACE_TABLE_PKG dependencies on PO_PRICE_DIFF_LOOKUPS_V

Line 1389: -- from the po_price_diff_lookups_v values

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

Line 1392: FROM po_price_diff_lookups_v ppdl

1388: -- update the interface table with the price_type values
1389: -- from the po_price_diff_lookups_v values
1390: UPDATE pon_auc_price_differ_int papdi
1391: SET price_type = (SELECT Nvl(MAX(ppdl.price_differential_type),'PRICE_TYPE_INVALID')
1392: FROM po_price_diff_lookups_v ppdl
1393: WHERE papdi.price_type_name = ppdl.price_differential_dsp(+)),
1394:
1395: price_type_desc = (SELECT Nvl(MAX(ppdl.price_differential_desc),'PRICE_DESC_INVALID')
1396: FROM po_price_diff_lookups_v ppdl

Line 1396: FROM po_price_diff_lookups_v ppdl

1392: FROM po_price_diff_lookups_v ppdl
1393: WHERE papdi.price_type_name = ppdl.price_differential_dsp(+)),
1394:
1395: price_type_desc = (SELECT Nvl(MAX(ppdl.price_differential_desc),'PRICE_DESC_INVALID')
1396: FROM po_price_diff_lookups_v ppdl
1397: WHERE papdi.price_type_name = ppdl.price_differential_dsp(+))
1398: WHERE batch_id = p_batch_id
1399: AND price_type_name <> 'EMPTY_PRICE_TYPE_NAME';
1400: