APPS.PO_CLM_CLO_UTIL dependencies on PON_BID_ITEM_PRICES

Line 159: FROM pon_bid_item_prices

155:
156: ELSIF p_product='PON BID' THEN
157: SELECT Nvl(clm_info_flag,'N'),clm_funded_flag
158: INTO x_clm_info_flag, x_clm_funded_flag
159: FROM pon_bid_item_prices
160: WHERE BID_NUMBER = p_line_id
161: AND auction_header_id = p_document_id;
162:
163: END IF;

Line 198: FROM pon_bid_item_prices

194:
195: ELSIF p_product='PON BID' THEN
196: /* SELECT LINE_NUM_DISPLAY
197: INTO l_line_num
198: FROM pon_bid_item_prices
199: WHERE BID_NUMBER = p_line_id
200: AND auction_header_id = p_document_id;*/
201: l_line_num := p_line_id;
202: END IF;

Line 255: FROM pon_bid_item_prices

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);*/
258:
259: END IF;

Line 315: FROM pon_bid_item_prices

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);
318:
319:

Line 357: FROM pon_bid_item_prices

353: AND line_number = p_group_line_id;
354: ELSIF p_product = 'PON BID' THEN
355: SELECT group_line_id
356: INTO l_group_line_id
357: FROM pon_bid_item_prices
358: WHERE auction_header_id = p_document_id
359: AND bid_number = p_group_line_id;
360: END IF;
361:

Line 976: FROM pon_bid_item_prices

972: BEGIN
973:
974: SELECT line_num_display,group_line_id
975: INTO l_from_disp_line_num,l_from_group_line_id
976: FROM pon_bid_item_prices
977: WHERE bid_number = p_document_id
978: AND line_number = p_from_line_id
979: AND auction_line_number = -1;
980:

Line 984: FROM pon_bid_item_prices

980:
981:
982: SELECT line_num_display,group_line_id
983: INTO l_to_disp_line_num ,l_to_group_line_id
984: FROM pon_bid_item_prices
985: WHERE bid_number = p_document_id
986: AND line_number = p_to_line_id
987: AND auction_line_number = -1;
988:

Line 995: FROM pon_bid_item_prices

991: INTO l_succ_line_id
992: FROM
993:
994: (SELECT line_num_display
995: FROM pon_bid_item_prices
996: WHERE bid_number = p_document_id
997: AND auction_line_number = -1
998: AND Nvl(l_from_GROUP_LINE_ID,-1) = Nvl(GROUP_LINE_ID,-1)
999: AND line_num_display > l_from_disp_line_num

Line 1020: FROM pon_bid_item_prices

1016: INTO l_pred_line_id
1017: FROM
1018:
1019: (SELECT line_num_display
1020: FROM pon_bid_item_prices
1021: WHERE bid_number = p_document_id
1022: AND auction_line_number = -1
1023: AND Nvl(l_from_GROUP_LINE_ID,-1) = Nvl(group_line_id,-1)
1024: AND line_num_display < l_from_disp_line_num