APPS.PON_AUCTION_PKG dependencies on PON_THREADS

Line 10998: l_subject PON_THREADS.SUBJECT%TYPE;

10994: l_msg_sent_date DATE;
10995: l_null_date DATE;
10996: l_msg_suffix PON_AUC_DOCTYPES.MESSAGE_SUFFIX%TYPE;
10997: l_auction_title PON_AUCTION_HEADERS_ALL.AUCTION_TITLE%TYPE;
10998: l_subject PON_THREADS.SUBJECT%TYPE;
10999: l_sender_name VARCHAR2(350);
11000: l_recipient_name VARCHAR2(350);
11001: l_preparer_tp_name HZ_PARTIES.PARTY_NAME%TYPE;
11002: l_task_name PON_NEG_TEAM_MEMBERS.TASK_NAME%TYPE;

Line 11051: FROM pon_threads pt,

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

Line 11099: FROM PON_THREADS PT,

11095: PTE.FROM_FIRST_NAME FIRST_NAME,
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

Line 11229: pon_threads pt,

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
11233: AND pt.discussion_id = pte.discussion_id