APPS.OTA_INITIALIZATION_WF dependencies on OTA_FORUM_THREADS

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

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

Line 1833: l_subject ota_forum_threads.subject%type;

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