DBA Data[Home] [Help]

APPS.AMW_FINSTMT_CERT_BES_PKG dependencies on AMW_OPINION_TYPES_B

Line 10065: AMW_OPINION_TYPES_B aot,

10061: CURSOR last_evaluation(l_risk_id number, l_organization_id number, l_process_id number) IS
10062: select distinct ao.opinion_log_id
10063: from AMW_OPINIONS_LOG ao,
10064: AMW_OBJECT_OPINION_TYPES aoot,
10065: AMW_OPINION_TYPES_B aot,
10066: FND_OBJECTS fo
10067: where ao.OBJECT_OPINION_TYPE_ID = aoot.OBJECT_OPINION_TYPE_ID
10068: and aoot.OPINION_TYPE_ID = aot.OPINION_TYPE_ID
10069: and aoot.OBJECT_ID = fo.OBJECT_ID

Line 10278: AMW_OPINION_TYPES_B aot,

10274: select distinct ao.opinion_log_id
10275: from
10276: AMW_OPINIONS_LOG ao,
10277: AMW_OBJECT_OPINION_TYPES aoot,
10278: AMW_OPINION_TYPES_B aot,
10279: FND_OBJECTS fo
10280: where ao.OBJECT_OPINION_TYPE_ID = aoot.OBJECT_OPINION_TYPE_ID
10281: and aoot.OPINION_TYPE_ID = aot.OPINION_TYPE_ID
10282: and aoot.OBJECT_ID = fo.OBJECT_ID