DBA Data[Home] [Help]

APPS.AMW_FINSTMT_CERT_BES_PKG dependencies on FND_OBJECTS

Line 2883: FROM FND_OBJECTS obj,

2879:
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

Line 3032: FROM FND_OBJECTS obj,

3028: CURSOR Get_Obj_Name (p_opinion_log_id NUMBER)
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

Line 10066: FND_OBJECTS fo

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
10070: and fo.obj_name = 'AMW_ORG_PROCESS_RISK'

Line 10279: FND_OBJECTS fo

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
10283: and fo.obj_name = 'AMW_ORG_CONTROL'