APPS.EAM_OBJECTINSTANTIATION_PUB dependencies on MTL_PARAMETERS

Line 223: FROM csi_item_instances cii, eam_org_maint_defaults eomd, mtl_parameters mp

219:
220: begin
221: select eomd.accounting_class_code, eomd.owning_department_id
222: INTO l_class_code, l_owning_department_id
223: FROM csi_item_instances cii, eam_org_maint_defaults eomd, mtl_parameters mp
224: WHERE cii.instance_id = p_maintenance_object_id
225: and eomd.object_type = 50
226: and eomd.object_id = cii.instance_id
227: and mp.organization_id = cii.last_vld_organization_id

Line 326: FROM csi_item_instances cii, mtl_parameters mp

322: -- with Active Status and Operational Log Flag Checked.
323:
324: SELECT mp.maint_organization_id, cii.instance_number, cii.active_start_date, cii.operational_log_flag
325: INTO l_maint_orgid, l_reference, l_event_date, l_operational_log_flag
326: FROM csi_item_instances cii, mtl_parameters mp
327: WHERE cii.instance_id = p_maintenance_object_id
328: AND cii.last_vld_organization_id = mp.organization_id ;
329:
330: IF (l_operational_log_flag = 'Y' ) THEN