APPS.PON_CLM_UTIL_PKG dependencies on PON_AUCTION_ITEM_PRICES_ALL

Line 213: from pon_auction_item_prices_all

209: l_clin_line Boolean := FALSE;
210: l_group_line_id Number;
211: BEGIN
212: select group_line_id into l_group_line_id
213: from pon_auction_item_prices_all
214: where auction_header_id = p_auction_header_id
215: and line_number = p_line_number;
216:
217: if ( l_group_line_id IS Null ) THEN

Line 229: from pon_auction_item_prices_all

225: IS
226: l_info_flag varchar2(1);
227: Begin
228: select nvl(clm_info_flag,'N') into l_info_flag
229: from pon_auction_item_prices_all
230: where auction_header_id = p_auction_header_id
231: and line_number = p_line_number;
232:
233: If ( l_info_flag = 'Y' ) Then

Line 245: from pon_auction_item_prices_all

241: IS
242: l_child_count Number;
243: BEGIN
244: select count(*) into l_child_count
245: from pon_auction_item_prices_all
246: where auction_header_id = p_auction_header_id
247: and group_line_id = p_line_number;
248:
249: if ( l_child_count = 0 ) then

Line 261: from pon_auction_item_prices_all

257: IS
258: l_child_count Number;
259: BEGIN
260: select count(*) into l_child_count
261: from pon_auction_item_prices_all
262: where auction_header_id = p_auction_header_id
263: and CLM_BASE_LINE_NUM = p_line_number;
264:
265: if ( l_child_count = 0 ) then