APPS.OTA_INITIALIZATION_WF dependencies on OTA_FORUM_THREADS

Line 1814: from ota_forum_messages ofm ,ota_forum_threads fth ,ota_forums_tl oft

1810: cursor get_message_details
1811: is
1812: select oft.name,fth.subject,ofm.person_id,ofm.contact_id,
1813: ofm.creation_date,ofm.message_body
1814: from ota_forum_messages ofm ,ota_forum_threads fth ,ota_forums_tl oft
1815: where oft.forum_id = ofm.forum_id
1816: and ofm.forum_thread_id = fth.forum_thread_id
1817: and ofm.forum_message_id = p_Forum_message_id
1818: and oft.language= USERENV('LANG');

Line 1829: l_subject ota_forum_threads.subject%type;

1825: and person_id is not null;
1826:
1827:
1828: l_forum_name ota_forums_tl.name%type;
1829: l_subject ota_forum_threads.subject%type;
1830: l_person_id ota_forum_messages.person_id%type;
1831: l_contact_id ota_forum_messages.contact_id%type;
1832: l_creation_date varchar2(50);
1833: l_message_body ota_forum_messages.message_body%type;