APPS.AMW_CONTROLS_PAGE_PKG dependencies on FND_CONCURRENT_PROGRAMS_VL

Line 306: from fnd_concurrent_programs_vl fcpv

302: and end_date is null;
303: elsif ((p_control_type = 'A' or p_control_type = 'C') AND (p_automation_type = '7')) then
304: select fcpv.user_concurrent_program_name
305: into l_control_source_name
306: from fnd_concurrent_programs_vl fcpv
307: ---where to_char(fcpv.concurrent_program_id) = p_control_source_id
308: where to_char(fcpv.concurrent_program_id) = l_control_source_id
309: and fcpv.application_id=p_application_id and fcpv.enabled_flag='Y';
310:

Line 318: from amw_controls_all_vl acav, fnd_concurrent_programs_vl fcpv

314: (select application_name from fnd_application_vl where application_id=fcpv.application_id) applicationName,
315: 'REPORT' lov_type,
316: 'A' control_type,
317: '7' automation_type
318: from amw_controls_all_vl acav, fnd_concurrent_programs_vl fcpv
319: where acav.application_id=fcpv.application_id and enabled_flag='Y'
320: ***/
321: elsif ((p_control_type = 'A' or p_control_type = 'C') AND (p_automation_type = '9')) then
322: select itl.NAME control_source_name