DBA Data[Home] [Help]

APPS.PON_TRANSFORM_BIDDING_PKG dependencies on DUAL

Line 96: FROM dual

92: v_has_est_qty_on_all_bid_lines := 'Y';
93:
94: /*SELECT 'N'
95: INTO v_has_est_qty_on_all_bid_lines
96: FROM dual
97: WHERE EXISTS (SELECT null
98: FROM pon_bid_item_prices pbip,
99: pon_auction_item_prices_all paip
100: WHERE pbip.auction_header_id = p_auction_header_id AND

Line 114: FROM dual

110: * Along with negotiation lines, Check if all unsolicited lines has quantity or not.
111: */
112: SELECT 'N'
113: INTO v_has_est_qty_on_all_bid_lines
114: FROM dual
115: WHERE EXISTS ((SELECT null
116: FROM pon_bid_item_prices pbip,
117: pon_auction_item_prices_all paip
118: WHERE pbip.auction_header_id = p_auction_header_id AND