DBA Data[Home] [Help]

APPS.PON_OPEN_INTERFACE_PVT dependencies on PO_UDA_AG_TEMPLATE_USAGES

Line 4009: FROM po_uda_ag_template_usages usages

4005: AND purchase_basis <> 'GOODS') LOOP
4006: BEGIN
4007: SELECT
4008: usages.attribute_group_id INTO l_attr_group_id
4009: FROM po_uda_ag_template_usages usages
4010: WHERE usages.attribute_category = 'PRICING'
4011: AND usages.template_id = l_uda_template_id
4012: AND usages.attribute1 = (SELECT clm_idc_type FROM pon_auction_item_prices_all WHERE auction_Header_id = x_auction_header_id AND line_number=complex_pricing_rec.line_number)
4013: AND usages.attribute2 = (SELECT clm_contract_type FROM pon_auction_item_prices_all WHERE auction_Header_id = x_auction_header_id AND line_number=complex_pricing_rec.line_number);