DBA Data[Home] [Help]

APPS.AMW_ORG_CERT_EVAL_SUM_PVT dependencies on AMW_OPINIONS_LOG_V

Line 151: FROM amw_opinions_log_v opinion

147:
148: CURSOR get_evaluation_opinion_log
149: IS
150: SELECT opinion.opinion_log_id
151: FROM amw_opinions_log_v opinion
152: WHERE (opinion.authored_date IN (SELECT MAX(opinion2.authored_date)
153: FROM amw_opinions opinion2
154: WHERE opinion2.object_opinion_type_id = opinion.object_opinion_type_id
155: AND opinion2.pk1_value = opinion.pk1_value)