APPS.JTF_CTM_UTILITY_PVT dependencies on ALL_VIEWS

Line 385: /* ACHANDA : Bug # 3511203 : get apps schema and use it to get the view text from all_views */

381: l_apps_schema_name VARCHAR2(30);
382: BEGIN
383: --dbms_output.put_line('Inside Format_View_Text procedure');
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';

Line 391: SELECT Text into l_view_Text from all_views where view_name = p_View_Name and owner = l_apps_schema_name;

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:
393: l_select := instr(l_view_Text, 'SELECT');
394: --dbms_output.put_line('l_select - ' || to_char(l_select));
395: