APPS.PO_CLM_CLO_UTIL dependencies on DUAL

Line 223: FROM dual

219: -- l_line_num:= getlinenum(p_product,p_document_id,p_line_id);
220: IF p_product = 'PO' THEN
221: SELECT 'Y'
222: INTO l_flag
223: FROM dual
224: WHERE EXISTS (SELECT 'x'
225: FROM po_lines_merge_v
226: WHERE CLM_BASE_LINE_NUM = p_line_id AND draft_id = -1
227: AND PO_HEADER_ID=Nvl(p_document_id,PO_HEADER_ID));

Line 233: FROM dual

229: ELSIF p_product = 'ICX' THEN
230:
231: SELECT 'Y'
232: INTO l_flag
233: FROM dual
234: WHERE EXISTS (SELECT 'x'
235: FROM po_requisition_lines_all
236: WHERE CLM_BASE_LINE_NUM = p_line_id
237: AND REQUISITION_HEADER_ID=Nvl(p_document_id,REQUISITION_HEADER_ID));

Line 242: FROM dual

238:
239: ELSIF p_product = 'PON' THEN
240: SELECT 'Y'
241: INTO l_flag
242: FROM dual
243: WHERE EXISTS (SELECT 'x'
244: FROM pon_auction_item_prices_all
245: WHERE 1=1
246: AND CLM_BASE_LINE_NUM = p_line_id

Line 253: FROM dual

249: ELSIF p_product = 'OFFER' THEN
250: l_flag := 'N';
251: /*SELECT 'Y'
252: INTO l_flag
253: FROM dual
254: WHERE EXISTS (SELECT 'x'
255: FROM pon_bid_item_prices
256: WHERE CLM_BASE_LINE_NUM = p_line_id
257: AND auction_header_id = p_document_id);*/

Line 282: FROM dual

278: BEGIN
279: IF p_product = 'PO' THEN
280: SELECT 'Y'
281: INTO l_flag
282: FROM dual
283: WHERE NOT EXISTS (SELECT 'x'
284: FROM po_lines_merge_v
285: WHERE group_line_id = p_line_id AND draft_id = -1);
286:

Line 291: FROM dual

287:
288: ELSIF p_product = 'ICX' THEN
289: SELECT 'Y'
290: INTO l_flag
291: FROM dual
292: WHERE NOT EXISTS (SELECT 'x'
293: FROM po_requisition_lines_all
294: WHERE group_line_id = p_line_id);
295:

Line 302: FROM dual

298:
299: ELSIF p_product = 'PON' THEN
300: SELECT 'Y'
301: INTO l_flag
302: FROM dual
303: WHERE NOT EXISTS (SELECT 'x'
304: FROM pon_auction_item_prices_all
305: WHERE group_line_id = p_line_id
306: AND auction_header_id = p_document_id);

Line 313: FROM dual

309: --Unsolicited Lines Project
310: ELSIF p_product = 'OFFER' THEN
311: SELECT 'Y'
312: INTO l_flag
313: FROM dual
314: WHERE NOT EXISTS (SELECT 'x'
315: FROM pon_bid_item_prices
316: WHERE bid_number = p_document_id
317: AND group_line_id = p_line_id);