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 946: ' xdo_templates_vl T, fnd_concurrent_programs P, ' ||

942: --
943: function layout_enabled ( ProgramApplName varchar2,
944: ProgramShortName varchar2) return boolean is
945: sqlstmt varchar2(1000) := 'select count(*) from ' ||
946: ' xdo_templates_vl T, fnd_concurrent_programs P, ' ||
947: ' fnd_application A ' ||
948: ' where DS_APP_SHORT_NAME= :1 and data_source_code= :2 ' ||
949: ' and template_status = ''E'' and sysdate between ' ||
950: ' start_date and nvl(end_date, sysdate) ' ||