DBA Data[Home] [Help]

APPS.PON_AUCTION_DISCUSSION_PKG dependencies on PON_THREAD_ENTRIES

Line 89: FROM pon_thread_entries pte,

85:
86:
87: SELECT count(1)
88: INTO unread_message_count
89: FROM pon_thread_entries pte,
90: pon_auction_headers_all ah
91: WHERE ah.auction_header_id = p_auction_header_id
92: AND pte.discussion_id = l_discussion_id
93: AND (((pte.broadcast_flag = 'N' OR pte.broadcast_flag = 'G')

Line 175: PON_THREAD_ENTRIES PTE

171: BEGIN
172:
173: SELECT count(1) into l_reply_count
174: FROM PON_TE_RECIPIENTS PTR,
175: PON_THREAD_ENTRIES PTE
176: WHERE PTR.replied_flag ='Y'
177: and PTR.entry_id = p_entry_id
178: and PTE.ENTRY_ID = PTR.ENTRY_ID
179: and PTR.to_company_id = p_auctioneer_tp_id -- Auctioneer's trading partner id