APPS.AMW_FINSTMT_CERT_BES_PKG dependencies on AMW_OBJECT_OPINION_TYPES

Line 2884: AMW_OBJECT_OPINION_TYPES oot,

2880: CURSOR Get_Obj_Name (p_opinion_log_id NUMBER) IS
2881: SELECT obj.obj_name , oplog.pk1_value, oplog.pk2_value, oplog.pk3_value,
2882: oplog.pk4_value, oplog.pk5_value, oplog.opinion_id
2883: FROM FND_OBJECTS obj,
2884: AMW_OBJECT_OPINION_TYPES oot,
2885: AMW_OPINIONS_LOG oplog
2886: WHERE oplog.opinion_log_id = p_opinion_log_id
2887: AND oplog.object_opinion_type_id = oot.object_opinion_type_id
2888: AND oot.object_id = obj.object_id;

Line 3033: AMW_OBJECT_OPINION_TYPES oot,

3029: IS
3030: SELECT obj.obj_name , oplog.pk1_value, oplog.pk2_value, oplog.pk3_value,
3031: oplog.pk4_value, oplog.pk5_value, oplog.opinion_id
3032: FROM FND_OBJECTS obj,
3033: AMW_OBJECT_OPINION_TYPES oot,
3034: AMW_OPINIONS_LOG oplog
3035: WHERE oplog.opinion_log_id = p_opinion_log_id
3036: AND oplog.object_opinion_type_id = oot.object_opinion_type_id
3037: AND oot.object_id = obj.object_id;

Line 10064: AMW_OBJECT_OPINION_TYPES aoot,

10060: --in risk association table, if type = 'PROCESS_FINCERT', pk1=certification_id, pk2=organization_id, pk3=process_id, pk4=opinion_log_id
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

Line 10277: AMW_OBJECT_OPINION_TYPES aoot,

10273: CURSOR last_evaluation(l_organization_id number, l_control_id number) IS
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