APPS.AMW_PUBLIC_PKG dependencies on AMW_OPINIONS_V

Line 12: from amw_opinions_v

8: begin
9:
10: select audit_result
11: into l_last_audit_status
12: from amw_opinions_v
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)

Line 19: (select max(last_update_date) from amw_opinions_v

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 =
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)

Line 44: select max(last_update_date) into l_last_update_date from amw_opinions_v

40: l_last_update_date date;
41:
42: begin
43:
44: select max(last_update_date) into l_last_update_date from amw_opinions_v
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)