APPS.PO_CLM_CLO_UTIL dependencies on PO_LINES_MERGE_V

Line 141: FROM po_lines_merge_v

137: BEGIN
138: IF p_product = 'PO' THEN
139: SELECT Nvl(clm_info_flag,'N'),clm_funded_flag
140: INTO x_clm_info_flag, x_clm_funded_flag
141: FROM po_lines_merge_v
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

Line 180: FROM po_lines_merge_v

176: BEGIN
177: IF p_product = 'PO' THEN
178: SELECT LINE_NUM --line_num_display
179: INTO l_line_num
180: FROM po_lines_merge_v
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

Line 225: FROM po_lines_merge_v

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));
228:
229: ELSIF p_product = 'ICX' THEN

Line 284: FROM po_lines_merge_v

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:
287:
288: ELSIF p_product = 'ICX' THEN

Line 341: FROM po_lines_merge_v

337: BEGIN
338: IF p_product = 'PO' THEN
339: SELECT group_line_id
340: INTO l_group_line_id
341: FROM po_lines_merge_v
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