APPS.PON_AUCTION_PKG dependencies on PON_THREADS

Line 11834: l_subject PON_THREADS.SUBJECT%TYPE;

11830: l_msg_sent_date DATE;
11831: l_null_date DATE;
11832: l_msg_suffix PON_AUC_DOCTYPES.MESSAGE_SUFFIX%TYPE;
11833: l_auction_title PON_AUCTION_HEADERS_ALL.AUCTION_TITLE%TYPE;
11834: l_subject PON_THREADS.SUBJECT%TYPE;
11835: l_sender_name VARCHAR2(350);
11836: l_recipient_name VARCHAR2(350);
11837: l_preparer_tp_name HZ_PARTIES.PARTY_NAME%TYPE;
11838: l_task_name PON_NEG_TEAM_MEMBERS.TASK_NAME%TYPE;

Line 11887: FROM pon_threads pt,

11883: SELECT
11884: distinct pte.from_id TO_PARTY_ID,
11885: PON_LOCALE_PKG.get_party_display_name(pte.from_id,2, userenv('LANG')) TO_PARTY_NAME,
11886: pte.from_first_name FIRST_NAME, pte.from_last_name LAST_NAME
11887: FROM pon_threads pt,
11888: pon_thread_entries pte
11889: WHERE pt.discussion_id = p_discussion_id
11890: AND pt.discussion_id = pte.discussion_id
11891: AND pt.thread_number = pte.thread_number

Line 11935: FROM PON_THREADS PT,

11931: PTE.FROM_FIRST_NAME FIRST_NAME,
11932: PTE.FROM_LAST_NAME LAST_NAME,
11933: PTE.FROM_COMPANY_ID COMPANY_ID,
11934: PTE.FROM_COMPANY_NAME COMPANY_NAME
11935: FROM PON_THREADS PT,
11936: PON_THREAD_ENTRIES PTE,
11937: PON_TE_RECIPIENTS PTR
11938: WHERE PT.DISCUSSION_ID = p_discussion_id
11939: AND PT.DISCUSSION_ID = PTE.DISCUSSION_ID

Line 12065: pon_threads pt,

12061: l_publish_auction_now_flag
12062: FROM pon_auction_headers_all auh,
12063: pon_auc_doctypes pad,
12064: pon_thread_entries pte,
12065: pon_threads pt,
12066: pon_discussions pd
12067: WHERE pte.entry_id = p_entryid
12068: AND pd.discussion_id = pte.discussion_id
12069: AND pt.discussion_id = pte.discussion_id