APPS.PON_AUCTION_PO_PKG dependencies on PON_AUCTION_ATTRIBUTES

Line 131: pon_auction_attributes paa

127: CURSOR attribute_info IS
128:
129: SELECT replace(pbav.attribute_name, fnd_global.local_chr(13)), pbav.value
130: FROM pon_bid_attribute_values pbav,
131: pon_auction_attributes paa
132: WHERE pbav.auction_header_id = p_auction_header_id and
133: pbav.bid_number = p_bid_number and
134: pbav.line_number = p_line_number and
135: pbav.sequence_number > 0 and

Line 230: FROM pon_bid_attribute_values pbav, pon_auction_attributes paa

226: CURSOR attribute_info IS
227:
228: SELECT replace(pbav.attribute_name, fnd_global.local_chr(13)),
229: pbav.value, paa.sequence_number
230: FROM pon_bid_attribute_values pbav, pon_auction_attributes paa
231: WHERE pbav.auction_header_id = p_auction_header_id and
232: pbav.bid_number = p_bid_number and
233: pbav.line_number = -1 and
234: paa.auction_header_id = pbav.auction_header_id and

Line 242: FROM pon_auction_attributes paa

238: nvl(paa.display_only_flag, 'N') = 'N'
239: UNION
240: SELECT replace(paa.attribute_name, fnd_global.local_chr(13)),
241: paa.value, paa.sequence_number
242: FROM pon_auction_attributes paa
243: WHERE paa.auction_header_id = p_auction_header_id and
244: paa.line_number = -1 and
245: nvl(paa.display_only_flag, 'N') = 'Y'
246: ORDER BY 3;