DBA Data[Home] [Help]

APPS.AMW_CONTROLS_PAGE_PKG dependencies on AMW_PROCESS

Line 1174: from amw_process ap,

1170: l_obj varchar2(2000);
1171: BEGIN
1172: select vl.name
1173: into l_obj
1174: from amw_process ap,
1175: amw_objective_associations ao,
1176: amw_process_objectives_vl vl
1177: where ao.object_type = 'CONTROL'
1178: and ao.pk1 = p_process_id

Line 1176: amw_process_objectives_vl vl

1172: select vl.name
1173: into l_obj
1174: from amw_process ap,
1175: amw_objective_associations ao,
1176: amw_process_objectives_vl vl
1177: where ao.object_type = 'CONTROL'
1178: and ao.pk1 = p_process_id
1179: and ao.pk2 = p_risk_id
1180: and ao.pk3 = p_control_id