DBA Data[Home] [Help]

APPS.PON_BID_DEFAULTING_PKG dependencies on PON_PARTY_LINE_EXCLUSIONS

Line 371: FROM pon_party_line_exclusions le, pon_auction_item_prices_all al

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)

Line 1623: FROM pon_party_line_exclusions le, pon_auction_item_prices_all al

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)