APPS.PON_UNSOL_UTIL_PKG dependencies on DUAL

Line 232: FROM dual

228: l_has_ref VARCHAR2(1);
229: BEGIN
230: SELECT 'Y'
231: INTO l_has_ref
232: FROM dual
233: WHERE EXISTS
234: (SELECT 1 FROM pon_bid_item_references WHERE bid_number = p_bid_number AND line_number = p_line_number);
235:
236: RETURN l_has_ref;

Line 254: FROM dual

250: l_has_unsol_lines := 'N';
251:
252: SELECT 'Y'
253: INTO l_has_unsol_lines
254: FROM dual
255: WHERE EXISTS
256: (SELECT 1 FROM pon_bid_item_prices WHERE auction_header_id = p_auc_header_id AND auction_line_number = -1);
257:
258: RETURN l_has_unsol_lines;

Line 276: FROM dual

272: l_has_unsol_lines := 'N';
273:
274: SELECT 'Y'
275: INTO l_has_unsol_lines
276: FROM dual
277: WHERE EXISTS
278: (SELECT 1 FROM pon_bid_item_prices WHERE bid_number = p_bid_number AND auction_line_number = -1);
279:
280: RETURN l_has_unsol_lines;

Line 853: FROM dual

849: l_has_unsol_lines := 'N';
850:
851: SELECT 'Y'
852: INTO l_has_unsol_lines
853: FROM dual
854: WHERE EXISTS
855: (SELECT 1 FROM pon_bid_item_prices
856: WHERE bid_number = p_bid_number
857: AND auction_line_number = -1

Line 883: FROM dual

879: l_has_awarded_ref := 'N';
880:
881: SELECT 'Y'
882: INTO l_has_awarded_ref
883: FROM dual
884: WHERE EXISTS
885: (SELECT 1
886: FROM pon_bid_item_prices pbip,
887: pon_bid_item_references pbir