APPS.BIV_RT_AGENT_MGR_PKG dependencies on JTF_RS_WEB_AVAILABLE_V

Line 293: and exists ( SELECT 1 FROM JTF_RS_WEB_AVAILABLE_V avl

289: update biv_tmp_rt2 rpt
290: set col12 = 'Y'
291: WHERE session_id = l_session_id
292: and report_code = 'BIV_RT_AGENT_REPORT'
293: and exists ( SELECT 1 FROM JTF_RS_WEB_AVAILABLE_V avl
294: WHERE avl.resource_id = rpt.id);
295: commit;
296: ---
297: --- Add a row fot toal of all column