APPS.AMW_CONTROLS_PAGE_PKG dependencies on AMW_OPINIONS_V
Line 841: FROM AMW_OPINIONS_V aov
837: BEGIN
838: BEGIN
839: SELECT DECODE(aov.audit_result_code,'EFFECTIVE','Y','N')
840: INTO CTRL_EFF 841: FROM AMW_OPINIONS_V aov 842: WHERE aov.object_name = 'AMW_ORG_CONTROL'
843: AND aov.opinion_type_code = 'EVALUATION'
844: AND aov.pk3_value = P_ORGANIZATION_ID
845: AND aov.pk1_value = P_CONTROL_ID