APPS.POS_CLM_UTIL_PKG dependencies on PO_REQUISITION_LINES_ALL

Line 122: FROM po_requisition_lines_all

118: WHERE po_line_id = p_line_id;
119: ELSIF p_product = 'ICX' THEN
120: SELECT Nvl(clm_info_flag,'N'),clm_funded_flag
121: INTO x_clm_info_flag, x_clm_funded_flag
122: FROM po_requisition_lines_all
123: WHERE requisition_line_id = p_line_id;
124: ELSIF p_product ='PON' THEN
125: SELECT Nvl(clm_info_flag,'N'),clm_funded_flag
126: INTO x_clm_info_flag, x_clm_funded_flag

Line 161: FROM po_requisition_lines_all

157: WHERE po_line_id = p_line_id;
158: ELSIF p_product = 'ICX' THEN
159: SELECT LINE_NUM
160: INTO l_line_num
161: FROM po_requisition_lines_all
162: WHERE requisition_line_id = p_line_id;
163: ELSIF p_product ='PON' THEN
164: /*SELECT LINE_NUM_DISPLAY
165: INTO l_line_num

Line 211: FROM po_requisition_lines_all

207: SELECT 'Y'
208: INTO l_flag
209: FROM dual
210: WHERE EXISTS (SELECT 'x'
211: FROM po_requisition_lines_all
212: WHERE CLM_BASE_LINE_NUM = p_line_id
213: AND REQUISITION_HEADER_ID=Nvl(p_document_id,REQUISITION_HEADER_ID));
214:
215: ELSIF p_product = 'PON' THEN

Line 268: FROM po_requisition_lines_all

264: SELECT 'Y'
265: INTO l_flag
266: FROM dual
267: WHERE NOT EXISTS (SELECT 'x'
268: FROM po_requisition_lines_all
269: WHERE group_line_id = p_line_id);
270:
271:
272:

Line 321: FROM po_requisition_lines_all

317: WHERE po_line_id = p_group_line_id;
318: ELSIF p_product = 'ICX' THEN
319: SELECT group_line_id
320: INTO l_group_line_id
321: FROM po_requisition_lines_all
322: WHERE requisition_line_id = p_group_line_id;
323: ELSIF p_product = 'PON' THEN
324: SELECT group_line_id
325: INTO l_group_line_id