APPS.PO_CLM_CLO_UTIL dependencies on PO_REQUISITION_LINES_ALL

Line 146: FROM po_requisition_lines_all

142: WHERE po_line_id = p_line_id AND draft_id = -1;
143: ELSIF p_product = 'ICX' THEN
144: SELECT Nvl(clm_info_flag,'N'),clm_funded_flag
145: INTO x_clm_info_flag, x_clm_funded_flag
146: FROM po_requisition_lines_all
147: WHERE requisition_line_id = p_line_id;
148: ELSIF p_product ='PON' THEN
149: SELECT Nvl(clm_info_flag,'N'),clm_funded_flag
150: INTO x_clm_info_flag, x_clm_funded_flag

Line 185: FROM po_requisition_lines_all

181: WHERE po_line_id = p_line_id AND draft_id = -1;
182: ELSIF p_product = 'ICX' THEN
183: SELECT LINE_NUM
184: INTO l_line_num
185: FROM po_requisition_lines_all
186: WHERE requisition_line_id = p_line_id;
187: ELSIF p_product ='PON' THEN
188: /*SELECT LINE_NUM_DISPLAY
189: INTO l_line_num

Line 235: FROM po_requisition_lines_all

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));
238:
239: ELSIF p_product = 'PON' THEN

Line 293: FROM po_requisition_lines_all

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:
296:
297:

Line 346: FROM po_requisition_lines_all

342: WHERE po_line_id = p_group_line_id AND draft_id = -1;
343: ELSIF p_product = 'ICX' THEN
344: SELECT group_line_id
345: INTO l_group_line_id
346: FROM po_requisition_lines_all
347: WHERE requisition_line_id = p_group_line_id;
348: ELSIF p_product = 'PON' THEN
349: SELECT group_line_id
350: INTO l_group_line_id