64: -- populate PRICING_BASIS
65: update pon_auc_price_elements_int pape
66: set pape.pricing_basis = (
67: select lookup_code
68: from fnd_lookups
69: where lookup_type = 'PON_PRICING_BASIS'
70: and meaning = pape.pricing_basis_name
71: )
72: where pape.batch_id = p_batch_id
853: when
854: (
855: selected_datatype not in (
856: select lookup_code
857: from fnd_lookups
858: where lookup_type = 'PON_AUCTION_ATTRIBUTE_TYPE'
859: )
860: )
861: then into pon_interface_errors
1216: from
1217: pon_price_elements pe,
1218: pon_price_element_types pet,
1219: pon_price_element_types_tl petl,
1220: fnd_lookups fl,
1221: pon_item_prices_interface ip
1222: where
1223: ip.batch_id = p_batch_id
1224: and pe.auction_header_id = p_auction_template_id