DBA Data[Home] [Help]

APPS.PON_AUCTION_PKG dependencies on PON_TE_RECIPIENTS

Line 11101: PON_TE_RECIPIENTS PTR

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
11105: AND PTE.ENTRY_ID = PTR.ENTRY_ID

Line 11153: FROM pon_te_recipients ptr

11149: SELECT ptr.to_id TO_PARTY_ID,
11150: PON_LOCALE_PKG.get_party_display_name(ptr.to_id,2, userenv('LANG')) TO_PARTY_NAME,
11151: ptr.to_first_name FIRST_NAME,
11152: ptr.to_last_name LAST_NAME
11153: FROM pon_te_recipients ptr
11154: WHERE ptr.entry_id = p_entryId
11155: AND ptr.to_id <> p_sender_id;
11156:
11157: