2757: SELECT owning_department_id
2758: ,area_id
2759: INTO l_department_id
2760: ,l_location_id
2761: FROM eam_org_maint_defaults
2762: WHERE object_type = 50
2763: AND object_id = p_instance_header_tbl(tab_row).instance_id;
2764: -- Defining when others as constraints were not defined in eam schema
2765: -- for the eam_org_maint_defaults table.
2761: FROM eam_org_maint_defaults
2762: WHERE object_type = 50
2763: AND object_id = p_instance_header_tbl(tab_row).instance_id;
2764: -- Defining when others as constraints were not defined in eam schema
2765: -- for the eam_org_maint_defaults table.
2766: EXCEPTION
2767: WHEN OTHERS THEN
2768: NULL;
2769: END ;