APPS.AMW_LOAD_AUDIT_PROCEDURE_DATA dependencies on AMW_OPINION_COMPONTS_B

Line 508: select opinion_component_id into v_overall from amw_opinion_componts_b

504:
505: fnd_file.put_line (fnd_file.LOG, 'Getting the component Id');
506: -- T0 Update the Control Effectiveness Details
507:
508: select opinion_component_id into v_overall from amw_opinion_componts_b
509: where opinion_component_code = 'OVERALL' and object_opinion_type_id =
510: (select object_opinion_type_id from AMW_OBJECT_OPINION_TYPES where object_id =
511: (select object_id from fnd_objects where obj_name = 'AMW_ORG_AP_CONTROL'));
512:

Line 513: select opinion_component_id into v_design from amw_opinion_componts_b

509: where opinion_component_code = 'OVERALL' and object_opinion_type_id =
510: (select object_opinion_type_id from AMW_OBJECT_OPINION_TYPES where object_id =
511: (select object_id from fnd_objects where obj_name = 'AMW_ORG_AP_CONTROL'));
512:
513: select opinion_component_id into v_design from amw_opinion_componts_b
514: where opinion_component_code = 'DESIGN' and object_opinion_type_id =
515: (select object_opinion_type_id from AMW_OBJECT_OPINION_TYPES where object_id =
516: (select object_id from fnd_objects where obj_name = 'AMW_ORG_AP_CONTROL'));
517:

Line 518: select opinion_component_id into v_operating from amw_opinion_componts_b

514: where opinion_component_code = 'DESIGN' and object_opinion_type_id =
515: (select object_opinion_type_id from AMW_OBJECT_OPINION_TYPES where object_id =
516: (select object_id from fnd_objects where obj_name = 'AMW_ORG_AP_CONTROL'));
517:
518: select opinion_component_id into v_operating from amw_opinion_componts_b
519: where opinion_component_code = 'OPERATING' and object_opinion_type_id =
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: