APPS.PON_AUCTION_PO_PKG dependencies on PON_AUCTION_ATTRIBUTES

Line 151: pon_auction_attributes paa

147: CURSOR attribute_info IS
148:
149: SELECT replace(pbav.attribute_name, fnd_global.local_chr(13)), pbav.value
150: FROM pon_bid_attribute_values pbav,
151: pon_auction_attributes paa
152: WHERE pbav.auction_header_id = p_auction_header_id and
153: pbav.bid_number = p_bid_number and
154: pbav.line_number = p_line_number and
155: pbav.sequence_number > 0 and

Line 268: FROM pon_bid_attribute_values pbav, pon_auction_attributes paa

264: CURSOR attribute_info IS
265:
266: SELECT replace(pbav.attribute_name, fnd_global.local_chr(13)),
267: pbav.value, paa.sequence_number
268: FROM pon_bid_attribute_values pbav, pon_auction_attributes paa
269: WHERE pbav.auction_header_id = p_auction_header_id and
270: pbav.bid_number = p_bid_number and
271: pbav.line_number = -1 and
272: paa.auction_header_id = pbav.auction_header_id and

Line 280: FROM pon_auction_attributes paa

276: nvl(paa.display_only_flag, 'N') = 'N'
277: UNION
278: SELECT replace(paa.attribute_name, fnd_global.local_chr(13)),
279: paa.value, paa.sequence_number
280: FROM pon_auction_attributes paa
281: WHERE paa.auction_header_id = p_auction_header_id and
282: paa.line_number = -1 and
283: nvl(paa.display_only_flag, 'N') = 'Y'
284: ORDER BY 3;

Line 368: FROM pon_bid_attribute_values pbav, pon_auction_attributes paa

364: CURSOR attribute_info IS
365:
366: SELECT replace(pbav.attribute_name, fnd_global.local_chr(13)),
367: pbav.value, paa.sequence_number
368: FROM pon_bid_attribute_values pbav, pon_auction_attributes paa
369: WHERE pbav.auction_header_id = p_auction_header_id and
370: pbav.bid_number = p_bid_number and
371: pbav.line_number = -1 and
372: paa.auction_header_id = pbav.auction_header_id and

Line 380: FROM pon_auction_attributes paa

376: nvl(paa.display_only_flag, 'N') = 'N'
377: UNION
378: SELECT replace(paa.attribute_name, fnd_global.local_chr(13)),
379: paa.value, paa.sequence_number
380: FROM pon_auction_attributes paa
381: WHERE paa.auction_header_id = p_auction_header_id and
382: paa.line_number = -1 and
383: nvl(paa.display_only_flag, 'N') = 'Y'
384: ORDER BY 3;