DBA Data[Home] [Help]

APPS.AMW_LOAD_AUDIT_PROCEDURE_DATA dependencies on FND_OBJECTS

Line 511: (select object_id from fnd_objects where obj_name = 'AMW_ORG_AP_CONTROL'));

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

Line 516: (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:
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 =

Line 521: (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:
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

Line 526: 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');
529: FOR eff_details_rec IN c_effec_details LOOP
530: