APPS.AMW_LOAD_AUDIT_PROCEDURE_DATA dependencies on AMW_OPINION_TYPES_B

Line 524: where opinion_type_id = (select opinion_type_id from AMW_OPINION_TYPES_b

520: (select object_opinion_type_id from AMW_OBJECT_OPINION_TYPES where object_id =
521: (select object_id from fnd_objects where obj_name = 'AMW_ORG_AP_CONTROL'));
522:
523: select object_opinion_type_id into v_opinion_object_id from AMW_OBJECT_OPINION_TYPES
524: where opinion_type_id = (select opinion_type_id from AMW_OPINION_TYPES_b
525: where opinion_type_code = 'EVALUATION') and object_id = (select object_id from
526: fnd_objects where obj_name = 'AMW_ORG_AP_CONTROL');
527:
528: fnd_file.put_line (fnd_file.LOG, 'Updating Control evaluation details');