APPS.AMW_CONTROLS_PAGE_PKG dependencies on AMW_OPINIONS

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

Line 847: from AMW_OPINIONS aov2

843: AND aov.opinion_type_code = 'EVALUATION'
844: AND aov.pk3_value = P_ORGANIZATION_ID
845: AND aov.pk1_value = P_CONTROL_ID
846: AND aov.authored_date = (select max(aov2.authored_date)
847: from AMW_OPINIONS aov2
848: where aov2.object_opinion_type_id = aov.object_opinion_type_id
849: and aov2.pk3_value = aov.pk3_value
850: and aov2.pk1_value = aov.pk1_value);
851: ---AND aov.audit_result_code <> 'EFFECTIVE';