APPS.AMW_PUBLIC_PKG dependencies on FND_OBJECTS

Line 17: and object_id = (select object_id from fnd_objects where obj_name = 'AMW_ORG_PROCESS') )

13: where pk1_value = p_process_id and pk3_value = p_org_id
14: and object_opinion_type_id =
15: (select object_opinion_type_id from AMW_OBJECT_OPINION_TYPES
16: where opinion_type_id = (select opinion_type_id from amw_opinion_types_b where opinion_type_code = p_mode)
17: and object_id = (select object_id from fnd_objects where obj_name = 'AMW_ORG_PROCESS') )
18: and last_update_date =
19: (select max(last_update_date) from amw_opinions_v
20: where pk1_value = p_process_id and pk3_value = p_org_id
21: and object_opinion_type_id =

Line 24: and object_id = (select object_id from fnd_objects where obj_name = 'AMW_ORG_PROCESS') ) );

20: where pk1_value = p_process_id and pk3_value = p_org_id
21: and object_opinion_type_id =
22: (select object_opinion_type_id from AMW_OBJECT_OPINION_TYPES
23: where opinion_type_id = (select opinion_type_id from amw_opinion_types_b where opinion_type_code = p_mode)
24: and object_id = (select object_id from fnd_objects where obj_name = 'AMW_ORG_PROCESS') ) );
25:
26: return l_last_audit_status;
27:
28: exception

Line 49: and object_id = (select object_id from fnd_objects where obj_name = 'AMW_ORG_PROCESS') );

45: where pk1_value = p_process_id and pk3_value = p_org_id
46: and object_opinion_type_id =
47: (select object_opinion_type_id from AMW_OBJECT_OPINION_TYPES
48: where opinion_type_id = (select opinion_type_id from amw_opinion_types_b where opinion_type_code = p_mode)
49: and object_id = (select object_id from fnd_objects where obj_name = 'AMW_ORG_PROCESS') );
50:
51: return l_last_update_date;
52:
53: exception