APPS.EAM_ASSET_LOG_PVT dependencies on MTL_PARAMETERS

Line 86: FROM mtl_parameters mp, csi_item_instances cii

82: IF p_event_type='EAM_SYSTEM_EVENTS' THEN
83: BEGIN
84: SELECT mp.maint_organization_id, cii.operational_log_flag
85: INTO l_organization_id, l_status
86: FROM mtl_parameters mp, csi_item_instances cii
87: WHERE mp.organization_id = cii.last_vld_organization_id
88: AND cii.instance_id = p_instance_id;
89:
90: IF (l_status = 'N' or l_status is NULL) THEN

Line 570: from mtl_parameters

566: SAVEPOINT EAM_ASSET_LOG_PVT_SV;
567:
568: begin
569: select nvl(maint_organization_id, p_organization_id) into l_organization_id
570: from mtl_parameters
571: where organization_id = p_organization_id;
572: exception
573: WHEN NO_DATA_FOUND THEN
574:

Line 697: FROM mtl_parameters mp, csi_item_instances cii

693: x_return_status := FND_API.G_RET_STS_SUCCESS;
694:
695: BEGIN
696: SELECT mp.maint_organization_id INTO l_organization_id
697: FROM mtl_parameters mp, csi_item_instances cii
698: WHERE mp.organization_id = cii.last_vld_organization_id
699: AND cii.instance_id = p_instance_id;
700:
701: EXCEPTION

Line 950: FROM mtl_parameters

946: l_instance_id := l_cmetid.instance_id;
947: l_instance_number := l_cmetid.instance_number;
948:
949: SELECT maint_organization_id INTO l_organization_id
950: FROM mtl_parameters
951: WHERE organization_id = l_cmetid.org_id;
952:
953: EAM_ASSET_LOG_PVT.validate_event(
954: p_event_date => p_event_date,