APPS.BSC_UPDATE_LOG dependencies on BSC_MESSAGE_LOGS

Line 195: ' FROM bsc_message_logs'||

191: TYPE t_cursor IS REF CURSOR;
192:
193: c_messages t_cursor; -- h_sessionid
194: c_messages_sql VARCHAR2(2000) := 'SELECT message'||
195: ' FROM bsc_message_logs'||
196: ' WHERE last_update_login = :1'||
197: ' ORDER BY last_update_date';
198:
199: h_sessionid NUMBER := USERENV('SESSIONID');

Line 201: h_message bsc_message_logs.message%TYPE;

197: ' ORDER BY last_update_date';
198:
199: h_sessionid NUMBER := USERENV('SESSIONID');
200:
201: h_message bsc_message_logs.message%TYPE;
202:
203:
204: BEGIN
205: OPEN c_messages FOR c_messages_sql USING h_sessionid;