DBA Data[Home] [Help]

APPS.PON_AUCTION_PKG dependencies on PON_THREAD_ENTRIES

Line 11052: pon_thread_entries pte

11048: distinct pte.from_id TO_PARTY_ID,
11049: PON_LOCALE_PKG.get_party_display_name(pte.from_id,2, userenv('LANG')) TO_PARTY_NAME,
11050: pte.from_first_name FIRST_NAME, pte.from_last_name LAST_NAME
11051: FROM pon_threads pt,
11052: pon_thread_entries pte
11053: WHERE pt.discussion_id = p_discussion_id
11054: AND pt.discussion_id = pte.discussion_id
11055: AND pt.thread_number = pte.thread_number
11056: AND pte.from_id <> p_sender_id

Line 11100: PON_THREAD_ENTRIES PTE,

11096: PTE.FROM_LAST_NAME LAST_NAME,
11097: PTE.FROM_COMPANY_ID COMPANY_ID,
11098: PTE.FROM_COMPANY_NAME COMPANY_NAME
11099: FROM PON_THREADS PT,
11100: PON_THREAD_ENTRIES PTE,
11101: PON_TE_RECIPIENTS PTR
11102: WHERE PT.DISCUSSION_ID = p_discussion_id
11103: AND PT.DISCUSSION_ID = PTE.DISCUSSION_ID
11104: AND PT.THREAD_NUMBER = PTE.THREAD_NUMBER

Line 11228: pon_thread_entries pte,

11224: l_open_auction_now_flag ,
11225: l_publish_auction_now_flag
11226: FROM pon_auction_headers_all auh,
11227: pon_auc_doctypes pad,
11228: pon_thread_entries pte,
11229: pon_threads pt,
11230: pon_discussions pd
11231: WHERE pte.entry_id = p_entryid
11232: AND pd.discussion_id = pte.discussion_id