APPS.FND_CONC_SSWA dependencies on FND_CONCURRENT_PROGRAMS

Line 128: from fnd_concurrent_requests r, fnd_concurrent_programs p

124: end loop;
125:
126: select r.program_application_id , p.concurrent_program_name
127: into app_id, prog_short_name
128: from fnd_concurrent_requests r, fnd_concurrent_programs p
129: where r.request_id = reqid
130: and r.concurrent_program_id = p.concurrent_program_id
131: and r.program_application_id = p.application_id;
132:

Line 885: ' xdo_templates_vl T, fnd_concurrent_programs P, ' ||

881: --
882: function layout_enabled ( ProgramApplName varchar2,
883: ProgramShortName varchar2) return boolean is
884: sqlstmt varchar2(1000) := 'select count(*) from ' ||
885: ' xdo_templates_vl T, fnd_concurrent_programs P, ' ||
886: ' fnd_application A , xdo_ds_definitions_vl D ' ||
887: ' where T.ds_app_short_name= :1 and T.data_source_code= :2 ' ||
888: ' and T.template_status = ''E'' ' ||
889: ' and D.data_source_status = ''E'' ' ||