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
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: