APPS.PO_CLM_CLO_UTIL dependencies on PON_AUCTION_ITEM_PRICES_ALL

Line 151: FROM pon_auction_item_prices_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
151: FROM pon_auction_item_prices_all
152: WHERE line_number = p_line_id
153: AND auction_header_id = p_document_id;
154:
155:

Line 190: FROM pon.pon_auction_item_prices_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
190: FROM pon.pon_auction_item_prices_all
191: WHERE line_number = p_line_id
192: AND auction_header_id = p_document_id;*/
193: l_line_num := p_line_id;
194:

Line 244: FROM pon_auction_item_prices_all

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
247: AND auction_header_id = p_document_id);
248:

Line 304: FROM pon_auction_item_prices_all

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);
307:
308:

Line 351: FROM pon_auction_item_prices_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
351: FROM pon_auction_item_prices_all
352: WHERE auction_header_id = p_document_id
353: AND line_number = p_group_line_id;
354: ELSIF p_product = 'PON BID' THEN
355: SELECT group_line_id

Line 896: FROM pon_auction_item_prices_all

892: BEGIN
893:
894: SELECT line_num_display,group_line_id
895: INTO l_from_disp_line_num,l_from_group_line_id
896: FROM pon_auction_item_prices_all
897: WHERE line_number = p_from_line_id
898: AND auction_header_id = p_document_id;
899:
900:

Line 903: FROM pon_auction_item_prices_all

899:
900:
901: SELECT line_num_display,group_line_id
902: INTO l_to_disp_line_num ,l_to_group_line_id
903: FROM pon_auction_item_prices_all
904: WHERE line_number = p_to_line_id
905: AND auction_header_id = p_document_id;
906:
907: IF p_action = 'BEFORE' THEN

Line 913: FROM pon_auction_item_prices_all

909: INTO l_succ_line_id
910: FROM
911:
912: (SELECT line_num_display
913: FROM pon_auction_item_prices_all
914: WHERE auction_header_id = p_document_id
915: AND Nvl(l_from_GROUP_LINE_ID,-1) = Nvl(GROUP_LINE_ID,-1)
916: AND line_num_display > l_from_disp_line_num
917:

Line 937: FROM pon_auction_item_prices_all

933: INTO l_pred_line_id
934: FROM
935:
936: (SELECT line_num_display
937: FROM pon_auction_item_prices_all
938: WHERE auction_header_id = p_document_id
939: AND Nvl(l_from_GROUP_LINE_ID,-1) = Nvl(group_line_id,-1)
940: AND line_num_display < l_from_disp_line_num
941: