367: WHERE bl.bid_number = p_bid_number
368: AND bl.line_number BETWEEN p_batch_start AND p_batch_end
369: AND EXISTS
370: (SELECT le.line_number
371: FROM pon_party_line_exclusions le, pon_auction_item_prices_all al
372: WHERE al.auction_header_id = p_auc_header_id
373: AND al.line_number = bl.line_number
374: AND le.auction_header_id = al.auction_header_id
375: AND le.line_number = nvl(al.parent_line_number, al.line_number)
1619: WHERE bl.bid_number = p_bid_number
1620: AND bl.line_number BETWEEN p_batch_start AND p_batch_end
1621: AND EXISTS
1622: (SELECT le.line_number
1623: FROM pon_party_line_exclusions le, pon_auction_item_prices_all al
1624: WHERE al.auction_header_id = p_auc_header_id
1625: AND al.line_number = bl.line_number
1626: AND le.auction_header_id = al.auction_header_id
1627: AND le.line_number = coalesce(al.parent_line_number, al.group_line_id, al.clm_base_line_num,al.line_number)