[Home] [Help]
384:
385: /* ACHANDA : Bug # 3511203 : get apps schema and use it to get the view text from all_views */
386: SELECT oracle_username
387: INTO l_apps_schema_name
388: FROM fnd_oracle_userid
389: WHERE read_only_flag = 'U';
390:
391: SELECT Text into l_view_Text from all_views where view_name = p_View_Name and owner = l_apps_schema_name;
392: