APPS.POS_CLM_UTIL_PKG dependencies on PON_BID_ITEM_PRICES

Line 135: FROM pon_bid_item_prices

131:
132: ELSIF p_product='PON BID' THEN
133: SELECT Nvl(clm_info_flag,'N'),clm_funded_flag
134: INTO x_clm_info_flag, x_clm_funded_flag
135: FROM pon_bid_item_prices
136: WHERE BID_NUMBER = p_line_id
137: AND auction_header_id = p_document_id;
138:
139: END IF;

Line 174: FROM pon_bid_item_prices

170:
171: ELSIF p_product='PON BID' THEN
172: /* SELECT LINE_NUM_DISPLAY
173: INTO l_line_num
174: FROM pon_bid_item_prices
175: WHERE BID_NUMBER = p_line_id
176: AND auction_header_id = p_document_id;*/
177: l_line_num := p_line_id;
178: END IF;

Line 230: FROM pon_bid_item_prices

226: SELECT 'Y'
227: INTO l_flag
228: FROM dual
229: WHERE EXISTS (SELECT 'x'
230: FROM pon_bid_item_prices
231: WHERE CLM_BASE_LINE_NUM = p_line_id
232: AND auction_header_id = p_document_id);
233:
234: END IF;

Line 290: FROM pon_bid_item_prices

286: SELECT 'Y'
287: INTO l_flag
288: FROM dual
289: WHERE NOT EXISTS (SELECT 'x'
290: FROM pon_bid_item_prices
291: WHERE group_line_id = p_line_id
292: AND auction_header_id = p_document_id);
293:
294:

Line 332: FROM pon_bid_item_prices

328: AND line_number = p_group_line_id;
329: ELSIF p_product = 'PON BID' THEN
330: SELECT group_line_id
331: INTO l_group_line_id
332: FROM pon_bid_item_prices
333: WHERE auction_header_id = p_document_id
334: AND bid_number = p_group_line_id;
335: END IF;
336: