DBA Data[Home] [Help]

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