APPS.AMW_CONTROLS_PAGE_PKG dependencies on AMW_CONTROLS_ALL_VL

Line 67: from amw_controls_all_vl

63: n varchar2(1);
64: BEGIN
65: select preventive_control
66: into n
67: from amw_controls_all_vl
68: where control_rev_id = P_CONTROL_REV_ID;
69: ---and objective_code = P_OBJECTIVE_CODE;
70:
71: ---if n > 0 then

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