DBA Data[Home] [Help]

APPS.AMW_FINSTMT_CERT_MIG_PKG dependencies on AMW_OPINION_TYPES_B

Line 619: AMW_OPINION_TYPES_B aot,

615: CURSOR last_evaluation(l_risk_id number, l_organization_id number, l_process_id number) IS
616: select distinct ao.opinion_log_id
617: from AMW_OPINIONS_LOG ao,
618: AMW_OBJECT_OPINION_TYPES aoot,
619: AMW_OPINION_TYPES_B aot,
620: FND_OBJECTS fo
621: where ao.OBJECT_OPINION_TYPE_ID = aoot.OBJECT_OPINION_TYPE_ID
622: and aoot.OPINION_TYPE_ID = aot.OPINION_TYPE_ID
623: and aoot.OBJECT_ID = fo.OBJECT_ID

Line 829: AMW_OPINION_TYPES_B aot,

825: select distinct ao.opinion_log_id
826: from
827: AMW_OPINIONS_LOG ao,
828: AMW_OBJECT_OPINION_TYPES aoot,
829: AMW_OPINION_TYPES_B aot,
830: FND_OBJECTS fo
831: where ao.OBJECT_OPINION_TYPE_ID = aoot.OBJECT_OPINION_TYPE_ID
832: and aoot.OPINION_TYPE_ID = aot.OPINION_TYPE_ID
833: and aoot.OBJECT_ID = fo.OBJECT_ID